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!