Help Creating a Excel Spreadsheet

[truthseeker]

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.

[sosaiso]

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.

[truthseeker]

-{ Quote: "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." }-

UPDATE: I created one. CLOSED!