Hi,

With the 3 conditions you note the formula returns NO for me so I suggest
you check your data. Are they really number? Are the numbers smaller/larger
than you think they are because formatting is changing the way you are seeing
them?

Mike

"Gator Girl" wrote:

here's my formula
=IF(AND($D70,$L7<($E7-$F7),$AV7=AW7),AW7,"NO")
Argument 1 is true - D7 is greater than 0
Argument 2 is false - L7 is equal to E7-F7
Argument 3 is true €“ AV7 is greater than AW 7

Still €“ the formula is returning AW7 instead of NO

HELP!!!!