Excel IF Statements

April 24, 2009 at 09:15:16
Specs: Windows XP
I have two cells with yes or no statements, I would like the 3rd cell to output a yes, no, or maybe answer dependent on the combination of cells 1 & 2.

So far I have,

=IF(B2="Yes","Yes",IF(B2="No","No",IF(C2="No","Yes", IF(C2="Yes","Maybe",))))

The issue I am having is that the "Maybe" statement does not occur because it is over written by B2 "Yes" statement. Is there a way to get the 3rd (Maybe) statement to work?

See More: Excel IF Statements

Report •

April 24, 2009 at 13:26:58
If what your looking for is a Maybe for a Yes Yes combo then this should do it.




Report •
Related Solutions

Ask Question