If you only need to break down denominations of paper money, try this:

With
A2: (a numeric value)

B1: 20's
C1: 10's
D1: 5's
E1: 1's

B2: =INT(A2/20)
C2: =INT(MOD(A2,20)/10)
D2: =INT(MOD(A2,10)/5)
E2: =INT(MOD(A2,5)/1)

Copy those formulas down as far as you need.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Bec" wrote:

Hi i was wondering if anyone can help me with a template that calulates what
dominations of cash breakdown i need for a payroll amount. i have each amount
each employee will receive but i have to do it manually. a template would be
a great help.

thanks