Using the Greater/Lesser than with %'s

Ashley Klaers

I'm trying to build a formula for 3 separate columns where it generates a number on whether the % provided is below or above a certain threshold:
Unauthorized Return Rates < 0.5%
Administrative Return Rates < 3.0%

In my current formula it should say if the % is greater than 0.5%, it should list "1", and if less than 0.5% it should generate a 2, if empty, then the row stays empty if the Debit row matches the designated text. But no mater what % is listed in my column its just generating a 2 or blank. Its doing the same thing with the formula for 3.0%.

=IF(ISBLANK([Rate 1]@row ), "", IF(AND([Debit Ret Type]@row = "Unath. Debit Returns", [Rate 1)]@row > 0.5), 1, IF([Rate 1]@row < 0.5, 2, "")))

KPH

Hi @Ashley Klaers

Try changing 0.5 to 0.005 in the formula.

0.5% is 0.005.

0.5 is 50%. As all your figures are less than 50%, the formula will return 2.