I'd keep a table, probably on a separate sheet (or at least in separate
columns) that had an effective date and hourly rate. Suppose this is in
Sheet2, columns A and B.
Then your daily table would have date, and hours in columns A and B. In
column C calculate the 'cost' as =B2*vlookup(a2,Sheet2!A:B,2). This would
calculate the earnings based on the hours and date in row 2, and you could
copy this formula down through each row of the table.
My two cents. --Bruce


"Gary Keramidas" wrote:

let's say there is a constant value, $/hr or price of an item. so every line
number has a column to multiply by this value. once or twice a year, this
value may change.

do you just hide a column with that value replicated down until it needs to
be changed?

example, every line item is a day of the year. somebody makes $10 per hour.
sometime during the year, they get a raise and from then on the value in the
hours column needs to be multipled by the new rate.

what's the best way?

--


Gary