help with formula

[kate1971]

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 an
hourly rates. I want to be able to set up the spreadsheet so that h
only has to enter the number of each different type of lesson and th
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 ho
to acheive this...?!
Can anyone help, please

 

[hmm]

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.

 

[Ragdyer]

You can set-up a datalist with your variable values or include them in the
formula itself.
Since you're talking about 3 values only, it's simple enough to include them
in the formula.

Let's say that you're using minutes as the reference factor for the
calculation.
30 = $15
45 = $18
60 = $20

Column A contains the number of lessons,
Column B is the reference factor (length of lesson),

Try this formula:
=A1*LOOKUP(B1,{30,45,60;15,18,20})