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.

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.

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