Multiple IFs in Excel

Ok so I want to analysis a value in a cell against a predefined "rule" to return a value.

The rule and resulting values are:

Revenue                                                            Value
 
0.00 - 399,999.99                                                  3
400,000.00 - 599,999,99                                        5
600,000.00 - 999,999.99                                        7
1,000,000.00 or greater                                         9

The cell I want to evaluate is J.
seamus9909Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Gašper KamenšekConnect With a Mentor Excel MVPCommented:
Hi,

Do this by Vlookup as shown in Example...

Have a nice day
samplevlookup.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.