| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning a value to a set of numbers
I am looking to create a formula that will give a certain range of numbers a
specific value. For example: If the number falls between 248 and 258 then give it a value of 4.5 If the number falls between 241 and 247 then give it a value of 4 If the number falls between 230 and 240 then give it a value of 3.5 If the number falls between 220 and 229 then give it a value of 3 If the number falls between 209 and 219 then give it a value of 2.5 If the number falls between 198 and 208 then give it a value of 2 and so forth. Any assistance with this problem would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Worksheet Functions | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| Assigning numbers to names | Excel Discussion (Misc queries) | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
