sir,
in My company pay Plenty of wage to lab our and staff, when currency note counting manually difficult and closing of cash book with denomination
is more Difficult when wages comes.
is formula just put into currency value at the cell, just automatically separated
Example 1 : Raja is person and his wage Rs 4789,
Babu is person and his wage Rs 4500
just i enter 4500 in to cell, automatically separate Rs 2000 under 1 notes and Rs 500 - under 3 notes and Rs 200 under 1 notes and Rs 100 under 10 notes and Rs 50 under 1 notes and Rs 20 under 1 notes and Rs 10 under 1 Notes, Rs 5 coin under 1 coin
and Rs 2 coin under 1 coin and Rs 1 coin under 1 coin should be come
Currency Notes
Name Wage Amount 2000 500 200 100 50 20 10 5 2 1
Raja 4589 1 3 1 10 1 1 1 1 1 1
Babu 4500 - 2 10 2 2 5
Example 2 :
if sufficient money availed above Formula should work and if sufficient not money availed for example of Babu, but i have different Notes, Rs 2000 note not availed and but i have Rs 500 notes - 2 nos, Rs 200 notes - 10 nos and Rs 100
nos -2, Rs 50 - 2 Nos and
Rs 20 Nos - 5 Nos.
but i well known Total wage - Rs 4589 + Rs 4500 : Rs 9089,
wage allocation denomination well know :
Rs 2000 x 1 : Rs 2000
Rs 500 x 5 : Rs 2500
Rs 200 x 11 : Rs 2200
Rs 100 x 2 : Rs 200
Rs 50 x 3 : Rs 150
Rs 20 x 6 ; Rs 180
Rs 10x1, : RS 10
Rs 5 x 1, ; Rs 5
Rs 2 x 1 ; Rs 2
Rs 1 x 1 ; Rs 1
--------------
Rs 9089
My Problem is i know denomination but which person which current Notes allocate ? based on Rs 2000 for first preference for Raja and Remaining Notes allocate to second person.
is any formula is there.. please tell.. already read cash denomination formula some website,
Rs total wage = total denomination -- auto allocation, i do some changes in formula , if sufficient note not availed and take formula next notes and allocate to that person,