consider this, column A has hourly rates, columns D thru
O are for the months of the year. I want to input for
each item, the number of hours used when entering the
data in the cells (for each month), but I want the cell
value to show the total $ value (ie, hours times the
hourly rate from column A)
For example if the hourly rate for A1 is $2517 and the
hours to input for D1 is 10. I want to enter 10 as the
data entry but I want the cell D1 to show 25,170 as the
value.