Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF/AND Statements
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 whe 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. -- case54321 ------------------------------------------------------------------------ case54321's Profile: http://www.excelforum.com/member.php...o&userid=24287 View this thread: http://www.excelforum.com/showthread...hreadid=378958 |
#2
|
|||
|
|||
=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 -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=378958 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|