formula range
 

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

formula range
 

explain, what u r trying to do


"Al Bank" wrote:

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

formula range
 

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" wrote:

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

formula range
 

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


"Al Bank" wrote:

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