How to write this 4 condition nested formula?

B

bortz

I'm trying to figure out how to write a formula to satisfy the followin
multiple conditions:

If cell v4>1 and cell x4="FR",-1 and
If cell v4=1 and cell x4="FR",3 and
If cell v4>1 and cell x4="CL",2 and
If cell v4=1 and cell x4="CL",-3

So I have 2 cells I'm working with here and 4 conditions that I want t
assign: either a -1,3,2, or -3, depending on whether the user types th
text FR or CL into cell X4.

Thanks and happy holidays.
Fran
 
S

swatsp0p

This should work for you...

=IF(AND(V4>1,X4="FR"),-1,IF(AND(V4=1,X4="FR"),3,IF(AND(V4>1,X4="CL"),2,IF(AND(V4=1,X4="CL"),-3,"N/A"))))

Returns "N/A" if none of the conditions are met, change to "" if you d
not want this to happen.

Good Luck

Bruc
 
B

bortz

Worked like a charm Bruce. A million thanks!
It's kind of frustrating when you know what to do but not how to g
about doing it.
It makes me appreciate what a programmer must go through sometimes.

Best regards,
Fran
 
S

swatsp0p

I'm glad it worked for you. Thanks for the feedback, it is alway
appreciated.

Cheers
 
Top