multiple if/than in one cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cheshire191 - 31 Aug 2005 20:05 GMT

basically i want to do this equation

if a1=a3 than w
if not check to see if a1=b3 than x
if not check to see if a1=c3 than y
if not check to see if a1=c4 than z

and so on.

can anyone tell me what function or functions i need to use to do this. i an
trying it with =IF and can't get it to work.

Reply to this Message

David Hepner - 31 Aug 2005 20:11 GMT

Try this:

=IF(A3=B3,"x",IF(A3=B4,"y",IF(A3=B5,"z","")))

> basically i want to do this equation
>
[quoted text clipped - 7 lines]
> can anyone tell me what function or functions i need to use to do this. i an
> trying it with =IF and can't get it to work.

Reply to this Message

cheshire191 - 31 Aug 2005 20:21 GMT

Sweet Dood .. thanks a million .. it worked like a charm!!!!

> Try this:
>
[quoted text clipped - 11 lines]
> > can anyone tell me what function or functions i need to use to do this. i an
> > trying it with =IF and can't get it to work.

Reply to this Message

Bob Phillips - 31 Aug 2005 20:14 GMT

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> basically i want to do this equation
>
[quoted text clipped - 7 lines]
> can anyone tell me what function or functions i need to use to do this. i an
> trying it with =IF and can't get it to work.

Reply to this Message

Bob Phillips - 31 Aug 2005 20:15 GMT

=IF(A1=A3,"w",IF(A1=B3,"x",IF(A1=C3,"y",IF(A1=D3,"z",""))))

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> basically i want to do this equation
>
[quoted text clipped - 7 lines]
> can anyone tell me what function or functions i need to use to do this. i an
> trying it with =IF and can't get it to work.

Reply to this Message