Solved need a formula for multiple conditions in excel

May 16, 2014 at 04:44:05
Specs: Windows 7
I have similar problem now
1)If value is less then 85% result should be -3
2)If value is grater than 86% to 90% result should be -2
3)if value is 91% to 99% result should be -1
4)if value is 100% to 110% result should be 2

See More: need a formula for multiple conditions in excel

Report •

#1
May 17, 2014 at 17:58:14
✔ Best Answer
Try this and see how it works for you:

=IF(A1<85,-3,IF(A1<91,-2,IF(A1<100,-1,IF(A1<=110,2,""))))

MIKE

http://www.skeptic.com/


Report •

#2
May 17, 2014 at 18:38:13
This is just a posting tip...

When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Need A Formula" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Thanks!
DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •
Related Solutions


Ask Question