LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jenna
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"