Creating an if formula

March 29, 2012 at 20:22:25
Specs: Windows 7
Hi I am trying to create an "if" formula that works in this manner..please help

range points
0-30 0
31-45 5
46-65 7
66-80 10
81-90 15
91-100 20
101-200 23


See More: Creating an if formula

Report •


#1
March 30, 2012 at 05:54:35
I would create a table with your ranges and points and then use VLOOKUP instead of an IF function.

If you set the range_lookup argument to TRUE (1) then it should work for you.

Read the Excel Help files (and Google) on the VLOOKUP function.

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


Report •
Related Solutions


Ask Question