| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 ANDS + 1 OR
=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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 ANDS + 1 OR
A THOUSAND THANK YOU'S
"bapeltzer" wrote: =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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 ANDS + 1 OR
Two ways are
=IF(OR(AND($D130,$L13<($E13-$F13),AU13=AV13),N13""),AV13,"NO") =IF($D130)*($L13<($E13-$F13))*(AU13=AV13))+(N13""),AV13,"NO") The latter form generalizes more easily. Multiplicaion of logicals behaves like AND, addition of logicals behaves like OR, and you can use parentheses as needed to control the order of evaluation. Jerry "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct assistance - need multiple ANDs and ORs | Excel Worksheet Functions | |||
| Multiple Nested IFs, ORs, Ands | Excel Worksheet Functions | |||
| Multiple ifs, and ands, and are not working | Excel Discussion (Misc queries) | |||
| Ifs and Ands - I'm confused! | Excel Worksheet Functions | |||
| Conditional Statement with ANDs | Excel Discussion (Misc queries) | |||
Hybrid Mode
