1. Need help sorting out ANDs and ORs in parameter query
in cell M13
=IF(AND($D13>0,$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
3. how to combine and's with or's in a if statement
4. multiple ifs ands & indirect or offset?
5. SUMPRODUCT with AND's and OR's?
6. Nesting IF's and AND's - a bit of help please...
9. Problem with calculations and multiple AND's in criteria
10. Nesting ,Ands
11. "ifs", "ands" & "vlookups"
12. Multiple Nested IFs, ORs, Ands
14. Specify list items with unlimited ANDs and ORs?
15. Excel file expands ands locks Excel