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

--
bort
-----------------------------------------------------------------------
bortz's Profile: http://www.excelforum.com/member.php...fo&userid=2943
View this thread: http://www.excelforum.com/showthread.php?threadid=49180

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

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=49180

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

--
bort
-----------------------------------------------------------------------
bortz's Profile: http://www.excelforum.com/member.php...fo&userid=2943
View this thread: http://www.excelforum.com/showthread.php?threadid=49180

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

Cheers

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=49180