+ Reply to Thread
Results 1 to 1 of 1

Calculate base on criteria

  1. #1
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Calculate base on criteria

    Hi,

    The attached table has the hourly rate company A, B, and C use to calculate the amount of money
    each company pay to the workers depend on the type of job (1, 2, or 3), date shift or night shift, and
    how many hours the workers had worked. This is just an excerpt from a very big spreadsheet so I'm trying to
    simplify it by trying to create a dialog box or something to give me the total pay for each company A, B, C when I put the work hour and select the type of shift, job.

    example: if someone tell me he/she work 40 hrs, date shift, job 2, then I should have a dialog box to enter all that info and it spit out the total pay from Company A, Company B and company C.

    Thank you very much,

    VBisgreat
    Attached Files Attached Files

+ Reply to Thread

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