conditional formulas

[Guest]

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

Any help is appreciated!

 

[Bernard Liengme]

You need to nest some IFs
=IF(A1>100%, 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

 

[Peo Sjoblom]

One way

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



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Dav]

If the value to be evaluated is in cell A1

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

Regards

Dav