I’m doing a MS excel spread sheet to calculate total commission to my sales people. I could use some help!?

Question

I’m doing a MS Excel spreadsheet to show the calculations of total sales commissions to each sales person at a rate of 4.625%.

Now my formula must have an ABSOLUTE REFERENCE and should be copied to other cells to illustrate that it works.

How do I go about doing this?

If you have the free time feel free to email me an actual excel 2003 file showing this to me with all the absolute references.

[e-mail]

Name of Salesperson
Sales for Year

Mortimer Adler
$3,015,082.00

John Dewey
$989,872.12

Robert Hutchins
$2,105,716.33

John Erskine
$2,212,884.41

Elizabeth Wilkins
$1,689,414.80

Vikki Spencer
$2,716,415.23

Dale Allee
$4,212,694.18

Answer 1

I have emailed you a spreadsheet with your request. I hope it works for you.

Answer 2

There are a couple of ways to do this. First, just use the constant .04625 in your formula or put a dollar sign $ in front of the cell you click on to enter it into your formula. Both serve the same purpose -- to keep the number constant. The results are:

commission
Mortimer Adler
$3,015,082.00 $139,447.54

John Dewey
$989,872.12 $45,781.59

Robert Hutchins
$2,105,716.33 $97,389.38

John Erskine
$2,212,884.41 $102,345.90

Elizabeth Wilkins
$1,689,414.80 $78,135.43

Vikki Spencer
$2,716,415.23 $125,634.20

Dale Allee
$4,212,694.18 $194,837.11