IF/AND Statements

  • Thread starter Thread starter case54321
  • Start date Start date
C

case54321

I'm getting into Excel more and I am trying to do something:

I have a combo box in cell B2 with options of "1" and "2".
I have a combo box in cell B4 with options of "1" and "2".

(the selected value writes to the cell B2 and B4 under the combo
boxes)

In cell B6, I would like to display a result where:

If B2=1 and B4=1, show "Hello"
If B2=1 and B4=2, show "Goodbye"
If B2=2 and B4=1, show "Go Away"
If B2=2 and B4=2, show "Thank You"

Is something like this possible? I have been trying to use an
"IF(AND..." but I must be doing something wrong. Your help is
appreciated.
 
=IF(B2=1,IF(B4=1,"Hello","Goodbye"),IF(B4=1,"Go away","thank you"))

assuming no other values are possible in b2 and b4

Mangesh
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct in matrix means 3
Formula for adding time 2
IF formula error 1
Can a cell be turned on or off? 1
Populate a combo Box 1
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
SORT data containing formula 5
Formula for subtracting from same number 5

Back
Top