Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to return a certain value if a number is within a range
I would like help in working out the following formula.
I have a number that is generated from the amount of defects for the month, which would be between 0-100. I would like to generate a new number from this that would be between 1-10. For example, if the total defects were between 20-30, i would like to see a 6 in the next colum, if it was between 80-100 I would like to see a 10 etc Any ideas on how to write this formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum data that is only within a specific number range? | Excel Worksheet Functions | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
How to add one number to a range of numbers | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |