Help Creating a Excel Spreadsheet

Discussion in 'other software & services' started by truthseeker, Jul 29, 2008.

Thread Status:
Not open for further replies.
  1. truthseeker

    truthseeker Former Poster

    Joined:
    Jan 26, 2008
    Posts:
    977
    Hi.

    Can someone please help me create an excel spreadsheet that calculates wages, commission and tax?

    I do about 50 different acting jobs in a financial year. On my payslips are contained the following 3 things:

    1. Wage
    2. Commission
    3. Tax

    I would like to have a place I can enter the company I worked for.

    Then I would love to have a way to enter these jobs into an spreadsheet which then calculates all the wage for all the different jobs.

    And then seperately calculates the commissions.

    And seperately calculates the total tax for all the jobs I do.

    Is this possible? If so, can I please ask someone help me create such a spreadsheet?

    Thank you so much.
     
    Last edited: Jul 29, 2008
  2. sosaiso

    sosaiso Registered Member

    Joined:
    Nov 12, 2005
    Posts:
    601
    I think it would be possible if you just had 6 columns:
    - Name of Job
    - Hours worked
    - Wage per hour
    - Total wage = name of job * hours worked
    - Commission
    - Tax

    Then at the bottom of each column just hit Alt+= (or you can use =sum())

    I think that should do most of what you want.
     
  3. truthseeker

    truthseeker Former Poster

    Joined:
    Jan 26, 2008
    Posts:
    977
    UPDATE: I created one. CLOSED!
     
    Last edited: Jul 29, 2008
Loading...
Thread Status:
Not open for further replies.