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.