Lookup wage Calculations

**Shogun101** · 12-01-2009, 10:22 AM

I have a spreadsheet that i use to work out my wages, however i now have different roles and these pay different rates.

I have the basics set up, but need to work out how to make it calculate my pay per shift dependant on the type of shift i have worked.

I have attached a screen shot of the current page,

In it i have currently used validation drop boxes for the location and worked columns with tables just to one side of the sheet.

The shift pay is the column i am having trouble with.
I would like it to change dependant on what is selected in the 'worked' column.
For most things it should just display basic plus holiday, however if supervisor is selcted in the work column, it should display basic plus holiday plus supervisor.

How can i achieve this??

**NBVC** · 12-01-2009, 10:26 AM

You mean?

=H6+I6+IF(D6="Supervisor",J6,0)

**Shogun101** · 12-01-2009, 12:42 PM

That is exactly what i needed!!

Thats alot for that, I thought it was going to have to be something alot more complicated than it actually was.

Cheers

**NBVC** · 12-01-2009, 01:04 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save