Formula

[bigwallclimber]

Good Morning,

I have an excel spreadsheet I work out wages on and the wages obviously differ from person to person. I am not sure if it can be done but what I would like to do is the following:

When the letter T (in a specific cell) is placed in the day worked area I want that to be $550 at the far right column where the wage is totalled so as we cover 31 days it will convert the letter to $550 per cell and at the right total the wage for that month period.
I also want to be able to do the same for other daily wage amounts for example:
R = $625
O = $500

I am not sure if it can be done but I would like to see if I can make my wpreadsheet do some of the work for me.

I hope some one can help.

[Bryan Hessey]

Good Morning,

I have an excel spreadsheet I work out wages on and the wages obviously differ from person to person. I am not sure if it can be done but what I would like to do is the following:

When the letter T (in a specific cell) is placed in the day worked area I want that to be $550 at the far right column where the wage is totalled so as we cover 31 days it will convert the letter to $550 per cell and at the right total the wage for that month period.
I also want to be able to do the same for other daily wage amounts for example:
R = $625
O = $500

I am not sure if it can be done but I would like to see if I can make my wpreadsheet do some of the work for me.

I hope some one can help.

good evening.

try something like

=SUM(IF(B2:I2="t",635,IF(B2:I2="s",500,IF(B2:I2="o",450,0))))+SUM(B2:I2)

with CSE (CTRL/Shift/Enter to enter that formula)

hth
---

[daddylonglegs]

One way is to create a table of all your wage codes and corresponding amounts, e.g. codes, "T", "R", "O" etc. in A1:A10 and amounts in B1:B10 then where your cells for a specific employee are A2:AE2 use this formula copied down

=SUMPRODUCT(SUMIF(A$1:A$10,A2:AE2,B$1:B$10))