# if /or argument

Options
edited 12/09/19

Sorry to bother with such a simple question, but what is the problem with this?

=IF(OR([Average 6mths]7 * 1.5 > [Current Monthly Usage]7, [ Average 6mths]7 * 0.5 < [Current Monthly Usage]7), 1, 0)

I am just trying to return 1 if between 50 and 150% and 0 of outside that range

• ✭✭✭✭✭✭
Options

=IF(OR([Average 6mths]7 * 1.5 > [Current Monthly Usage]7, [ Average 6mths]7 * 0.5 < [Current Monthly Usage]7), 1, 0)

You have a space in the underlined portion between the open square bracket and the start of the column name in your second set of the OR criteria. Try what is below.

=IF(OR([Average 6mths]7 * 1.5 > [Current Monthly Usage]7, [Average 6mths]7 * 0.5 < [Current Monthly Usage]7), 1, 0)

• Options

Thanks for that,

i figured it out.. i found that i had the argument around the wrong way!  Instead of looking for values outside of the range .... look for values inside the range.

=IF(OR([Average 6mths]13 * 2 < [Current Monthly Usage]13, [Average 6mths]13 * 0.33 > [Current Monthly Usage]13), 0, 1)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!