how do i calculate coinage denominations in excell for payroll

H

Hayeso

In Cell A1 put "Pay"

In Cell A3 put "Denomination"
In Cell B3 put "Count"
In Cell C3 pur =B1

In Cell A4 put the first denomination (e.g. 100)
In Cell A5 put the second denomination (e.g. 50)
..
..
Continue until the last denomination (e.g. 0.01)


In Cell B4 put "=INT(C3/A4)"
In Cell C4 put "=C3-(B4*A4)"

Drag the formulas in B4 and C4 down for each denomination.


To Test, Put a sample pay amount in B1
The denominations will appear in the count column.

It will look better if you hide column C
 
B

BenjieLop

You might want to search this NG (Keyword: denomination) and look fo
"bills to pay (denomination)." Myrna Larson has a solution that migh
help you out
 
Top