how do i calculate coinage denominations in excell for payroll

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

coinage 2
PAYROLL CALCULATION 4
Excel - Sliding decreasing scale (payroll tax calc) 2
payroll calculator for ontario canada, cant convert ontario rates. 1
Payroll 1
Payroll Calculator Excel 97 or later - what figures to use? 1
payroll calculation 4
How do you calculate payroll with tips? 1

Back
Top