bills on netpay (denomination)

[Guest]

Gentlemen,
is ther a formula in Excel to calculate how many bills of 100.00, 50.00
25.00, 10.00,
5.00 etc. you get fromn a netpay e.g. 1574.25? Thus 15 bills of 100.00, 1 of
50, 2 of 10.00 etc etc.

 

[Myrna Larson]

In B1:G1 put the bill denominations, i.e. the numbers:

100 50 20 10 5 1

In A2 put the amount, 1574.25

In B2 put this formula:

=INT($A2/$B$1)

In C2 put this formula:

=INT(($A2-SUMPRODUCT($B$1:B$1,$B2:B2))/C$1)

and copy it to the right, through G2.

In H2, put this formula for the cents:

=$A2-SUMPRODUCT($B$1:G$1,$B2:G2)