Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple if/then on one cell
here is basically what i want to do.
if a3=b3 than x if not than check to see if a3=b4 than y if not than check to see if a3=b5 than z i just don't know how to make excel understand. if there is a different command to use that would be cool too .. i just don't know it. thanks in advance. |
#2
|
|||
|
|||
Try this:
=IF(A3=B3,"x",IF(A3=B4,"y",IF(A3=B5,"z"))) "cheshire191" wrote: here is basically what i want to do. if a3=b3 than x if not than check to see if a3=b4 than y if not than check to see if a3=b5 than z i just don't know how to make excel understand. if there is a different command to use that would be cool too .. i just don't know it. thanks in advance. |
#3
|
|||
|
|||
cheshire191 Wrote: here is basically what i want to do. if a3=b3 than x if not than check to see if a3=b4 than y if not than check to see if a3=b5 than z i just don't know how to make excel understand. if there is a different command to use that would be cool too .. i just don't know it. thanks in advance. Hi cheshire191 Try this =IF(A3=B3,"x",IF(A3=B4,"y","z")), this will return z if A3 is not equal to B3 or B4 or =IF(A3=B3,"x",IF(A3=B4,"y",IF(A3=B5,"z","No Match"))), will return No Match if A3 is not equal to B3, B4 or B5 -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=400908 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple cell editing | Excel Worksheet Functions | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
generate multiple rows based on cell value | Excel Worksheet Functions | |||
Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
Multiple lines in 1 cell | Excel Discussion (Misc queries) |