Excel if Condition - Multiple calculations

August 8, 2011 at 00:46:18
Specs: Windows XP
I have a question to ask as under

Qty Slab Commission/bag Qty Amount Cummulative
(Tonne) (Tonne) (Rs.) (Rs.)
0-2500 Rs.17 2500 42500 42500
2501-5000 Rs.13 2500 32500 75000
5001-10000 Rs.11 5000 110000 185000
10001-20000 Rs.9 10000 90000 275000
20001-30000 Rs.8 10000 80000 355000
30000-50000 Rs.7 20000 140000 495000
>50001 Rs.6 7000 42000 537000
Total 57000 537000

How to calculate the Cummulative Amt as per different slabs achieved by an individual using if condition.

Regards

Rajesh H


See More: Excel if Condition - Multiple calculations

Report •

#1
August 8, 2011 at 13:47:25
Please click on the following line and read the instructions on how to post data so that your columns line up. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question