Now, we
can calculate the bonus for each sales rep. Each sales rep's
Total is entered in Column B. The
VLookup formula looks up the right
Commission in the Sales table. 7.
Try it: Calculate the Bonus Select
Cell D2. Enter the
following equation: =B2*C2. Try
This, Too: AutoFill the Formula Select
Cell D2. Use to
AutoFill handle to copy the formula from Cell D3 through D5. What Do
You See? The formula in Cell D5 is =B5*C5.
Memo to Self: ### means you
have too much money. Technically, the column is not wide enough to
display the numbers correctly You can make the column wider if you
wish.
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.3. Apply cell references in
formulas: Use Relative Cell References
|
|
| |
