multiple if/then on one cell

C

cheshire191

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.
 
P

Paul Sheppard

cheshire191 said:
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 ..
just
don't know it.

thanks in advance.
Click to expand...

Hi cheshire191

Try this >

=IF(A3=B3,"x",IF(A3=B4,"y","z")), this will return z if A3 is not equa
to B3 or B4

or

=IF(A3=B3,"x",IF(A3=B4,"y",IF(A3=B5,"z","No Match"))), will return N
Match if A3 is not equal to B3, B4 or B
 
Top