function used to get 30% of sale of $5000.00

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm taking a class in excel 2003. One of the quiz questions is:
B3 cost of sales equals 30% of sales. Create a formula in cell B7 to
calculate the cost of sales for January. Use an absolute reference to cellB3
in the formula.

Any help would be great!!
 
=$B$3*.30

A better quiz question would be: what is the advantage of using an absolute
reference for this calculation? None that I can discern.

Dave
 
Assuming January sales are in A7.....put this formula in B7

=$B$3*A7

As you copy it down column B, the A7 will increase to A8, A9, etc but the
$B$3 will stay the same........the dollar signs are what makes it an
Absolute Reference. Check the HELP section for more details.

hth
Vaya con Dios,
Chuck, CABGx3



"Help with quiz question" <Help with quiz
(e-mail address removed)> wrote in message
news:D[email protected]...
 
Back
Top