ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Nesting If Statement with "AND", "OR" conditions (https://www.excelbanter.com/excel-worksheet-functions/5354-nesting-if-statement-%22%22-%22%22-conditions.html)

Jenna

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

Biff

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
.


Jenna

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
.



Biff

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
.


.



All times are GMT +1. The time now is 11:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com