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
oh dear, just realised i had the < around the wrong way.
i turned it around and its working now haha.