worksheet formula

  • Thread starter Thread starter carmen
  • Start date Start date
C

carmen

I have a worksheet that I need to calculate the actual amount of hours times
the hourly rate then have the total in another field. I can get it to work
if I just use the three fields but I would like to just have the hourly rate
in only one field then in a blank field add the hours in then it will
automatically calulate the total.

Is their a way to do this or do I just need to stick with the three fields.

Thanks

Carmen
 
Hours in A1:A100

Rate in B1

Amount =SUM (A1:A100)*24*B1

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
As an example assume the hours are in A5 and the hourly rate is in C1. Then
make B5 read as follows: =$C$1*A5. The results will automatically appear in
B5. I suggest you use the "$" approach above so you can change the hourly
rate as needed in C1 to automatically change all B column values. Check
Excel help for absolute cell references as to when and how to use the "$"
above.

Good luck

WDA

end
 
You can set up one cell (say, A2) with the hourly rate, and then just
use $A$2 * Hours in your total field to get your result. That way you
only have to change one field should your hourly rate change.
 
Back
Top