worksheet formula

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
 
B

Bob Phillips

Hours in A1:A100

Rate in B1

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
W

W. D. Allen Sr.

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
 
G

gsering

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.
 
Top