Tutorials & Examples Web-help Blog

If statement with Between or > and <


#1

Hi

I am trying to use if statement and between or > and < with negative number.

if ([Field A] >=-1 or [Field A] <=1, ‘Rounding’, ‘Check Rec’)

Thanks


#2

Unary negation is currently not supported in EasyMorph. Negative numbers should be written as 0 minus the value. E.g.

if ([Field A] >=0-1 or [Field A] <=1, 'Rounding', 'Check Rec')

#3

Thanks.

Rykie