4 Replies Latest reply on Jun 23, 2016 9:17 PM by Ben Ben

    Dimension "A" or 160mm, whichever is greater

    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.