Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with formula range | Excel Discussion (Misc queries) | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Formula for a new range..... | Excel Discussion (Misc queries) | |||
Sum Formula that excludes other sum formula in range | Excel Worksheet Functions |