AnsweredAssumed Answered

Dimension "A" or 160mm, whichever is greater

Question asked by Ben Ben on May 25, 2016
Latest reply on Jun 23, 2016 by Ben Ben

In example below, i am trying to input an equation to give me

BODY= 3x BRANCHIDIA or 160mm whichever is higher...

 

im no wiz when it comes to excel but have tried:  =if("BRANCHDIA@Sketch1"*3<160,"BRANCHDIA@Sketch1"*3,160) and did not work.

 

please can someone point me in the right direction

 

 

 

*Edit

oh dear, just realised i had the < around the wrong way.

i turned it around and its working now haha.

Outcomes