If or statement

[ptrifile]

I have a bonus file that i am trying to work through. If AHT is Greater than 12.5 overall bonus should be zero, if quality is less than 90% than the overall bonus should be zero. I am using the following formula:

=IF(OR(W10<AI7,V10>AI8),"no bonus",(Y10+Z10)*AA10)

problem is that it is only "zeroing" out the cell if V10 is greater than 12.5. If W10 is less than 90% and V10 is not greater than 12.5 it is not "zeroing" out the total bonus. Is my formula wrong?

Hope this made sense.

Paul

 

[mintjulep]

Not so much. But I can imagine several things that might be wrong.

 

[SkipVought]

Please post ALL the values that are in the referenced cells:
[tt]
V10
W10
AI7
AI8
[tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

I'd almost bet that you're comparing a cell that is a percentage (i.e. 90% displayed, but the underlying value is 0.9) with a cell that is not a percentage (i.e. value is displayed as "90" and really is 90).

 

[Malagar]

You could also try using the AND function. It looks like you have 2 criteria that need to be met in order for the bonus to take effect.

Try this:

=IF([b]AND[/b](W10<AI7,V10>AI8),"no bonus",(Y10+Z10)*AA10)

Malagar