"Paul987" wrote:


I wish I saw this kind of effort put towards my problem!!


--
Paul987



A small correction in KL formula will also do I
think.=CHOOSE(1+(E920000)+(E940000),0,2000,(E9-40000)*0.15+2000)
This will give you zero for the sum below 20000 and Rs 2000 for the sum up
to 40000 and 15% of the value for the sum in excess over 40000 plus 2000.



------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=387502