Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conversion to value between 1 to 10 only!
I have a problem for an excel formula. In my example, there is one value in
cell D1: 15, and I want an excel formula which can convert it to 5. The objective of the excel formula is to convert 45 to 5, 10 to 10, 20 to 10, 30 to 10, 39 to 9 etc. I know my following excel function can do it 【IF(D140,D20-40,IF(D130,D1-30, IF(D120,D1-20,IF(D110,D1-10,D1))))】. My question is that is there any extremly simple excel formula which can convert those value immediately? Many thanks, Wilchong -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERSION | Excel Discussion (Misc queries) | |||
ESN conversion | Excel Worksheet Functions | |||
Conversion | Excel Discussion (Misc queries) | |||
Conversion | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |