AnsweredAssumed Answered

IF Statement in Assembly

Question asked by Kevin Wright on Jun 28, 2013
Latest reply on Jun 29, 2013 by Kevin Wright

I'm trying to get this equation to take the pattern count of a linear pattern in assembly in SW 2013 and then set another dimension equal to a constant based on the pattern count.  I keep getting the dreaded "Syntax of this equation is incorrect error" 

 

= iif ( "D1@LocalLPattern1" = 1 , 0 , iif ( "D1@LocalLPattern1" = 2 , 0.125 , iif ( "D1@LocalLPattern1" = 3 , 0.25 , iif ( "D1@LocalLPattern1" = 4 , 0.375 ) ) ) )

As an excel formula I have this below as the string and it works fine in excel.  The B12 is the Pattern Count Value:

=IF(B12=1,0,IF(B12=2,0.125,IF(B12=3,0.25,IF(B12=4,0.375))))

If someone could give me a direction on how to get this equation to work I would appreciate it. 

Outcomes