Absolute Reference in regards to Excel?

Question

I need to know how I put an absolute reference to figure out the total price in the spreadsheet below:
http://img528.imageshack.us/img528/2404/yahoolk7.png

Answer 1

You do NOT want to use absolute references in this case for totals.

Your normal formulas using relative references will work best.

In your Invoice Column you enter the amount. (col F)

In the next column (G) you use the formula

=F4*10%

Then your Price column (H) use the formula

=F4-G4

You can then use the fill handle to copy this formula all the way to the bottom without typing it over and over.

In your last row for the Total Sales cell use the AutoSum button to put in the function for totaling all the rows above it.

that's it.

Note that if there was a place to use absolute references it would be in calculating the discount since you have the 10% in a specific cell (D2) that you want to reference over and over - so this would make your formula =F4*$D$2.

EDIT: From your previous post your discount column would use an if function as recommended by other posters
=IF(F4>=5000,F4*10%,0)
all else would remain the same

Answer 2

VBMICA is correct. I suspect your teacher/prof wants to know you know how to set an absolute reference, and this is why you aren't permitted to subtract the column G values from column F values and why you are asking. If so, do this. I'm assuming 10% is cell D2 and the first Invoice Amount is cell F4. If so, this is the formula to enter into H4. =F4*D2. Press enter. Double click on H4 to activate the formula. Click in between the D and the 2 so your cursor is in between them. Press F4. This places a dollar sign before your D and your 2, making the cell reference to D2 absolute. Press enter. Click on the lower right hand corner, on the selection handle, and drag downward 9 rows. Since your cell reference to the 10% discount is absolute, and the invoice amount is relative, you successfully multiply each invoice amount times 10% in the remaining 9 rows. Congratulations!

Answer 3

For absoulute reference add a dollar sign ($) before letters and numbers e.g. for an absoulte refernce to F6 cell, change this address into $F$6.

For more information visit:
http://office.microsoft.com/en-us/excel/HP051983231033.aspx?pid=CH010036991033

and

http://office.microsoft.com/en-us/excel/HP052014411033.aspx?pid=CH010004901033

Answer 4

check out www.creativeparadox.jconserv.net
sign up and ask for a tutorial on excel or just post ur question up
o and dont worry signin up is free