| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I return a value in excel that looks at a range of number
I have a range of numbers 1-10 and 10-20 each range will need to return a
separate number. Example if the value is 6 return $5.00 if it is 11 return $4.00 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can I return a value in excel that looks at a range of number
Hi
What is the deciding factor as to what number is returned? You will either need a table and a VLOOKUP function or maybe a nested IF. Andy. "Help in Excel" <Help in wrote in message ... I have a range of numbers 1-10 and 10-20 each range will need to return a separate number. Example if the value is 6 return $5.00 if it is 11 return $4.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Mailing an excel range in the body of an e-mail | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
Linear Mode
