=IF(OR(AND($D130,$L13<($E13-$F13),AU13=AV13),N13<""),AV13,"NO")

"Gator Girl" wrote:

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