Forum Discussion

JenniferSilbers's avatar
JenniferSilbers
Qrew Trainee
3 years ago

Greater/less than with negative number formula

Hello, I am having trouble figuring out why my formula doesn't work.  I have tried several versions and none have worked so I need help. I have a field that is a % that could be negative or posi...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
If your field format is set to show as a percent, then the actual stored values are still saved as regular number.  So for example 1% is stored as 0.01.  I believe that Excel would be the same behaviour.

Try this

IF(
[%] >=-0.03, "Exceeded",
[%]<0.03, "BAD")

If the [%] is blank, then this should calculate to blank if the [%] field is set not to treat blank as zero (if its a data entry field) .


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------