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.
meuntome@yahoo.com
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
2007-07-20
04:11:44
·
2 answers
·
asked by
I have a question
3