Thread: 3 ANDS + 1 OR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gator Girl Gator Girl is offline
external usenet poster
 
Posts: 36
Default 3 ANDS + 1 OR

in cell M13

=IF(AND($D130,$L13<($E13-$F13),AU13=AV13),AV13,"NO")
returns a date in if all 3 statements are true, otherwise no.
I want an OR condition IF N13"", AV13 to come in before the "NO",
so that if all 3 of the first statements are true OR the last statement is
true, the date from AV13 results.

I've fooled around with this for 2 hours now, and I GIVE UP.

Once again, I am turning to the experts to save me.

Thanks