if /or argument

michaeld

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

Paul Newcome

=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)

michaeld

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)