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.