number entry

[tom donino]

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.

 

[Frank Kabel]

Hi
this would only be possib le using VBA (using the worksheet_change event
procedure). In your case I would consider using two cells. One for the entry
and the other one for the calculated result. No way to achieve your
requirements with formula alone with only one cell