Hi Champs,
I have a requirement to split up the amount to each slabs..
for example:
I have standard format like below from B1 to B8...
2000
1000
500
100
50
10
5
1
If I mention a amount like 8879 in a cell "A1", then output should be like below.......from c1 to c8..
4
0
1
3
1
0
1
4
Please help.. I have attached the sample.
Bookmarks