formula range

[Al Bank]

Trying to set up a formula by assigning a score to a sum or result
Result is 36

Points score
20 25 or less
24 26-32
20 33-36
14 37-45
8 45-50
0 >50

 

[Raz]

explain, what u r trying to do

 

[Sean Timmons]

Enter your lowest values, (0, 26,33, etc.) and place the score in first
column. then do a VLOOKUP.

=VLOOKUP(C2,A:B,2,1)

Assuming the score was in cell C2 and your table below is in columns A and B.

the ,1 at the end is a range lookup. any value from 0 to 25 will return a
value of 20.

The key is insuring the lookup value is the first column in your lookup.

 

[Al Bank]

Debt to Income: 36%
(based on gross pay) #N/A
30 <25
24 26%-32%
20 33%-36%
14 37%-45%
8 46%-50%
0 50% >
Trying to create a function to fill in #N/A