how to return a certain value if a number is within a range
What about defects between 0-20 and 30-80?
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
Portland, Oregon
"Caconz" wrote in message
...
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?
|