Results 1 to 4 of 4

Monthly payroll calculation

Threaded View

  1. #1
    Registered User
    Join Date
    05-14-2018
    Location
    Hong Kong
    MS-Off Ver
    MS 365
    Posts
    72

    Monthly payroll calculation

    I create 3 sheets in this payroll file.
    on Payroll in Jun-18, The cell H6 has set up the formula correctly but I want to look up the employee name from employee data sheet and set up the MPF contribution is 5% only if working period is more than 60 days. so where should the Vlookup put in this formula? in front of IF or after?

    How this formula set?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Monthly Payroll Overtime Calculation
    By truxhavenx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-02-2015, 04:42 PM
  2. Monthly update of main spreadsheet using data from Payroll file
    By carlos.delossantos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2015, 03:22 PM
  3. Creating a Semi-Monthly Payroll Calendar
    By dvanallen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2014, 08:39 PM
  4. monthly salary payroll
    By miguel_angeo in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-21-2013, 09:38 PM
  5. Excel formula for monthly payroll
    By Ombongi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-06-2013, 06:00 AM
  6. Calculating Vacation Accruals for bi-monthly payroll
    By Marbles21 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2012, 08:07 AM
  7. Calender for Semi-Monthly Payroll Purpose
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2012, 07:52 PM

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