Microsoft Office Tutorials and References
In Depth Information
To Enter Formulas Using Point Mode and Determine Totals in the Template
To Enter Formulas Using Point Mode and Determine Totals in the Template
The following steps use Point mode to enter the four formulas in Table 6–1 in the range D5:G5. After the
formulas are entered for JVC DVRs in row 5, the formulas will be copied for the remaining six companies. The Sum
button then is used to determine the totals in row 12.
1
Select cell D5, type = to start
the formula, click cell B5, type *
(asterisk), click cell C5, and then
click the Enter box in the formula
bar (Figure 6–9).
formula assigned
to cell D5
value of 1
2
appears in cell D5
Figure 6–9
2
Select cell E5, type
=round(c5/(1-.42),2) , and
then click the Enter box in the
formula bar to display the formula
=ROUND(C5/(1-0.42), 2) in the
formula bar and the value 3.45
(3.448276 rounded to two decimal
places) as the average unit price in
cell E5 (Figure 6–10).
ROUND function
assigned to cell E5
value of 2 / (1 - .42)
rounded to two decimal
places appears in cell E5
Figure 6–10
 
 
Search JabSto ::




Custom Search