Equations Operators

[overkill04]

Hi all

Just wondering what an easy way to perform an odd or even check would be in the equation editor.

eg. if "xxxx" is positive then ....
else negative then ....

Thanks



Specs, Intel Pentium M 2.16 Mhz
SW 2007 R2.2
1.5 Gb Ram
NVidia GE Force GO 6800 256Mb

 

[handleman]

thread559-181619

 

[EEnd]

The iif function can be used to return different values based on a condition. So to get a different value if xxx is odd than if it is even try:

iif(("xxx" mod 2) like 0, even_value, odd_value)

Eric