function used to get 30% of sale of $5000.00
 

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!!

function used to get 30% of sale of $5000.00
 

=$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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Help with quiz question" wrote:

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!!

function used to get 30% of sale of $5000.00
 

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
wrote in message
...
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!!