Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round to nearest 5000? | Excel Worksheet Functions | |||
Round to nearest 5000 | Excel Discussion (Misc queries) | |||
If function with date; if sale is Oct place sale $ amount here | Excel Worksheet Functions | |||
Displaying 5000 | Excel Discussion (Misc queries) | |||
skus in columm a for each sale, qty. of skus sold, each sale in co | Excel Worksheet Functions |