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
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 >
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 >
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 >
