Results 1 to 3 of 3

Need help on salary (pieces of money)

Threaded View

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    40

    Need help on salary (pieces of money)

    Dear All,

    I need some help. My company pay salary by cash and we have total 70 person.

    I want to create a automatic calculation on pieces of money needed but i don't know how to do that.

    Ex:

    RM1,532.85 for this month salary and i need an automatic calculation as below:

    RM100.00 = 15
    RM50.00 = 0
    RM20.00 = 1
    RM10.00 = 1
    RM5.00 = 0
    RM1.00 = 2
    RM0.50 = 1
    RM0.20 = 1
    RM0.10 = 1
    RM0.05 = 1


    Thank you!
    Last edited by arlu1201; 06-24-2013 at 06:31 AM. Reason: Removed email id.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1