Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

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.
0
seamus9909
Asked:
seamus9909
1 Solution
 
Gašper KamenšekExcel MVPCommented:
Hi,

Do this by Vlookup as shown in Example...

Have a nice day
samplevlookup.xlsx
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now