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
|