help with formula
 

I am trying to set up a spreadsheet for my husband's accounts.
He teaches and charges different rates for half hour, 3/4 hour and
hourly rates. I want to be able to set up the spreadsheet so that he
only has to enter the number of each different type of lesson and the
sheet will then calculate the amount earned automatically.
I cannot see how to do this at the moment.
I figure I somehow need to embed a formula in a range of cells but how
to acheive this...?!:confused:
Can anyone help, please?


--
kate1971
------------------------------------------------------------------------
kate1971's Profile: http://www.excelforum.com/member.php...o&userid=32604
View this thread: http://www.excelforum.com/showthread...hreadid=524029

help with formula
 

If a1, a2, and a3 contain the number of 1/2 hr, 3/4 hr, and 1 hr lessons, and
next to each one in column b is the amount he charges for that lesson, then
to calculate the total earned you can enter the following in any other cell:

=a1*b1 + a2*b2 + a3*b3.

Based on your comment about embedding a formula, I suspect your question
might be more complicated than this; let me know.

"kate1971" wrote:


I am trying to set up a spreadsheet for my husband's accounts.
He teaches and charges different rates for half hour, 3/4 hour and
hourly rates. I want to be able to set up the spreadsheet so that he
only has to enter the number of each different type of lesson and the
sheet will then calculate the amount earned automatically.
I cannot see how to do this at the moment.
I figure I somehow need to embed a formula in a range of cells but how
to acheive this...?!:confused:
Can anyone help, please?


--
kate1971
------------------------------------------------------------------------
kate1971's Profile: http://www.excelforum.com/member.php...o&userid=32604
View this thread: http://www.excelforum.com/showthread...hreadid=524029