Dear Bob,
thank for your suggestion! However, your suggested formula cannot convert 20
to 10, 30 to 10, 40 to 10 and etc!

How to revise your suggested formula in order to achieve those result?

Many thanks,
Wilchong


Bob Phillips wrote:
=D1-LOOKUP(D1,{10,20,30,40},{10,20,30,40})

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
[quoted text clipped - 11 lines]
Many thanks,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200805/1