Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nesting If Statement with "AND", "OR" conditions
Hi guys, I'm completely stumped and seeking any suggestions!
Here's what I'm trying to get my cell to do. If A15=2 and E55="YES" and E56="YES", then the cell says "YES", if one of those 3 isn't true, then "NO". But if A15=1 and (E55="YES" OR E56="YES"), then the cell says "YES", if it doesn't then "NO". This is what I have in my cell and I just don't know what do with it! =IF(AND(A15=2,E55="YES",E56="YES"),IF(OR(A15=1,E55 ="YES",E56="YES"),"YES","NO")) Is it possible to do this all in one cell? I would greatly appreciate any help! Sincerely, Jenna |
#2
|
|||
|
|||
Hi!
Try this: =IF(AND(A1=2,E5="YES",E6="YES"),"YES",IF(AND(OR (E5="YES",E6="YES"),A1=1),"YES","NO")) Biff -----Original Message----- Hi guys, I'm completely stumped and seeking any suggestions! Here's what I'm trying to get my cell to do. If A15=2 and E55="YES" and E56="YES", then the cell says "YES", if one of those 3 isn't true, then "NO". But if A15=1 and (E55="YES" OR E56="YES"), then the cell says "YES", if it doesn't then "NO". This is what I have in my cell and I just don't know what do with it! =IF(AND(A15=2,E55="YES",E56="YES"),IF(OR (A15=1,E55="YES",E56="YES"),"YES","NO")) Is it possible to do this all in one cell? I would greatly appreciate any help! Sincerely, Jenna . |
#3
|
|||
|
|||
Biff ~
Thank you so incredibly much. You don't know how helpful you have been! Ahhh I'm ecstatic! Extremely grateful, Jenna "Biff" wrote: Hi! Try this: =IF(AND(A1=2,E5="YES",E6="YES"),"YES",IF(AND(OR (E5="YES",E6="YES"),A1=1),"YES","NO")) Biff -----Original Message----- Hi guys, I'm completely stumped and seeking any suggestions! Here's what I'm trying to get my cell to do. If A15=2 and E55="YES" and E56="YES", then the cell says "YES", if one of those 3 isn't true, then "NO". But if A15=1 and (E55="YES" OR E56="YES"), then the cell says "YES", if it doesn't then "NO". This is what I have in my cell and I just don't know what do with it! =IF(AND(A15=2,E55="YES",E56="YES"),IF(OR (A15=1,E55="YES",E56="YES"),"YES","NO")) Is it possible to do this all in one cell? I would greatly appreciate any help! Sincerely, Jenna . |
#4
|
|||
|
|||
You're welcome and thanks for the feedback.
Biff -----Original Message----- Biff ~ Thank you so incredibly much. You don't know how helpful you have been! Ahhh I'm ecstatic! Extremely grateful, Jenna "Biff" wrote: Hi! Try this: =IF(AND(A1=2,E5="YES",E6="YES"),"YES",IF(AND(OR (E5="YES",E6="YES"),A1=1),"YES","NO")) Biff -----Original Message----- Hi guys, I'm completely stumped and seeking any suggestions! Here's what I'm trying to get my cell to do. If A15=2 and E55="YES" and E56="YES", then the cell says "YES", if one of those 3 isn't true, then "NO". But if A15=1 and (E55="YES" OR E56="YES"), then the cell says "YES", if it doesn't then "NO". This is what I have in my cell and I just don't know what do with it! =IF(AND(A15=2,E55="YES",E56="YES"),IF(OR (A15=1,E55="YES",E56="YES"),"YES","NO")) Is it possible to do this all in one cell? I would greatly appreciate any help! Sincerely, Jenna . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|