Formula - use % complete to determine whether in progress

Question

Hi!

I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anything other than "0%", "100%", or "Cancelled." But it's not working, and I have no clue why.

Here's the formula:

=IF(OR([% Complete]@row = "0%", [% Complete]@row = "100%", [% Complete]@row = "Cancelled"), false, true)

Here's a screenshot so you can see how it's failing to work:

What am I doing wrong? This seems like a simple formula.

Nic Larsen · Accepted Answer

Try:

=IF(OR([% Complete]@row = 0, [% Complete]@row = 1, [% Complete]@row = "Cancelled"), 0, 1)

In formulas, 1 = 100%, .5 = 50% and so on.