Thread: Conversion to value between 1 to 10 only!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wilchong via OfficeKB.com wilchong via OfficeKB.com is offline
external usenet poster
  
Posts: 90
Default 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

Reply With QuoteReply With Quote