View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gator Girl Gator Girl is offline
external usenet poster
 
Posts: 36
Default FORMULA NOT WORKING

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!!!!