• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Distribute the currency notes between the employees

Juniad

Juniad

Active Member
I have 120 different currency note which i want to distribute between the employees as per their salaries.
Sample sheet is attached.
 

Attachments

  • Cash salary Calc - Copy.xlsx
    11 KB · Views: 10
61271

In H2, copied across and down :

=INT(($E2-SUMPRODUCT($G$1:G$1*$G2:G2))/H$1)

Regards
Bosco
 

Attachments

  • Cash salary Calc -(BY).xlsx
    13.4 KB · Views: 10
You must log in or register to reply here.
Back
Top