Is there a way to have 4 conditions in one formula and cell? it is only
allowing me to enter 2. For example, IF100%,"FORMULA X",
IF=95%*AND<100%,"FORMULA Y",
IF<95%*AND=85%,"FORMULA Z"
IF<85%,0

Any help is appreciated!

You need to nest some IFs
=IF(A1100%, formula_x, IF(A1=95%, formula_b, IF(A1=85%, formula_c,
formula_d)))

Notice we do not need A1=95% AND < 100% since the 100% has already be
captured.
Likewise when we test to =85%, the cases greater than 95% are already
looked after.

IF can be read as ; IF (test_this, when_true_do_this, when false_do_this)
Nesting can be done only the 7 levels.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Beth104" wrote in message
...
Is there a way to have 4 conditions in one formula and cell? it is only
allowing me to enter 2. For example, IF100%,"FORMULA X",
IF=95%*AND<100%,"FORMULA Y",
IF<95%*AND=85%,"FORMULA Z"
IF<85%,0

Any help is appreciated!

One way

=CHOOSE(LOOKUP(A1,{0;0.85;0.95;1},{1;2;3;4}),0,"fo rmula Z","formula
Y","formula X")



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Beth104" wrote in message
...
Is there a way to have 4 conditions in one formula and cell? it is only
allowing me to enter 2. For example, IF100%,"FORMULA X",
IF=95%*AND<100%,"FORMULA Y",
IF<95%*AND=85%,"FORMULA Z"
IF<85%,0

Any help is appreciated!

If the value to be evaluated is in cell A1

IF(a11,"FORMULA X", IF(a1=0.95,"FORMULA Y",IF(a1=0.85,"FORMULA Z"
,0)))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=520097