multiple if/then on one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to return a formula 1
if statement 2
excel "IF" formula... if this possible ??? 0
Formulas 2
Formula Content linked to other cells formula Content 5
How to make Weighted Average 3
Multiple conditions 2
Using IF statement with Spell check 3

Back
Top