Info

The formula in F4 includes both relative and absolute formulas:

=IF(E4,ROUND(D4*$B$1,2),0). Thanks to the dollar signs inserted in B1, you can copy this formula down and it always multiplies the Total Price in this row by the tax rate in Cell B1.

The numerical results in Figure 6.4 are achieved by the formulas shown in Figure 6.5. (Ctrl+~ in Excel switches between normal view and formula view.) Considering that I had to enter formulas only in Rows 4 and 10, I think it is amazing that Excel was able to intelligently copy the formulas down the column.

Figure 6.4

These results in Columns D, F, and G are achieved by the formulas shown in Figure 6.5.

Microsoft Excel - ChäpEar6.xls pjj Bis Edc '¿tew insert Ffirmat Jocfe ffiirriav yelp jejuni . - - & * - ana 3 v gl«

pjj Bis Edc '¿tew insert Ffirmat Jocfe ffiirriav yelp jejuni . - - & * - ana 3 v gl«

0 0

Post a comment