Need a formula for multiple pay rates

[younglife12]

Hello,

My spreadsheet involves multiple pay scales for my work. I need a formula for the two fields (Skilled and Unskilled Columns L and M) I've been doing this manually but would be faster with a formula.

If task column (C9) equals Unskilled Labor return the total of Pay/Credit (K9) to Unskilled Column (M9)
If Task column (C9) equals Skilled Labor return the total of Pay/Credit (K9) to Skilled Column (M9)

Thanks in advance!

younglife12

younglife12

 

[iggydarsa]

Put this formula on L10 --> =IF(C10="Skilled Labor", K10, "")
Put this formula on M10 --> =IF(C10="Unskilled Labor", K10, "")

And copy down the formula

 

[Bosquedeguate]

Another way to do this is create a small table with two columns
Cell A1 and A2 have the strings:
Skilled Labor
Unskilled Labor

Cells B1 and B2 enter
42.00
18.00

I would put these on another sheet and name these 4 cells as “LaborRates”

In Cells J10 enter
=VLOOKUP(C10,LaborRates,2,false)

Copy the formula to C11 to C13

The advantage of using a lookup table is that if/when you have additional labor rates you will not have to change your code.

Also, if you have not done this … consider using a validation list for entries in column C. This list can be define from the first column of the LaborRates table.

Good luck!
Dios te bendiga

 

[younglife12]

Thank you so much for the quick answers. They were very helpful and I appreciate it!