+ Reply to Thread
Results 1 to 3 of 3

direct wages deduct Holiday, deduct Vacation,and calcaulate direct wages percentage indire

  1. #1
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    direct wages deduct Holiday, deduct Vacation,and calcaulate direct wages percentage indire

    I am trying to create formula to get indirect wages
    I have total wages and deduct holiday wages, deduct vacation and calculate direct labor % to get indirect wages.

    Total wages are $ 265229.00
    Holiday $ (20662.000
    Vacation $ (9181.00)
    Misc $ (75000.00)

    Net wages $160386.00
    then I want to deduct 45% of $ 160386.00 direct labor of $ (72173.70)

    $160386.00
    $(72173.70)

    $88212.30 indirect labor

    how can I write to get these result


    what I have so far $=+(H100-V105-V106+V102-H84*H108) donot know what I am doing wrong ?

    please some one can help me , that will be great, I really have to finish this file.

    thanks a lot in advance
    Last edited by Bitto; 09-19-2013 at 09:35 AM.

  2. #2
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: direct wages deduct Holiday, deduct Vacation,and calcaulate direct wages percentage in

    Quote Originally Posted by Bitto View Post
    $=+(H100-V105-V106+V102-H84*H108)
    Not sure if you mean this:
    Book1.xlsx

  3. #3
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: direct wages deduct Holiday, deduct Vacation,and calcaulate direct wages percentage in

    Thanks Evolta, It worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-11-2013, 12:00 AM
  2. Deduct Percentage if Value In Between
    By TehNoob2010 in forum Access Tables & Databases
    Replies: 8
    Last Post: 08-16-2012, 06:27 AM
  3. wages sheet
    By hopster in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-25-2011, 02:28 PM
  4. Overtime Wages
    By derekg1023 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-05-2006, 08:48 AM
  5. calculating wages
    By rooney2oons in forum Excel General
    Replies: 3
    Last Post: 08-19-2006, 08:10 AM

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