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 •

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



Report •

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.

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