Absolute reference

[college student]

In excel, how to calculate 7428 times 8% to total 8022. I can reach the answer with my calculator, but unable to come up with the right formula in Excel.

[Palmetto]

A1 = 7428
B1 formula: =($A$1*0.08)+$A$1

[college student]

Will Excel change the formula values using the black plus while I am dragging the 4-way arrow across the different cells?

[davesexcel]

try,
=a1*1.08

[Palmetto]

Will Excel change the formula values using the black plus while I am dragging the 4-way arrow across the different cells?

It will if you use Dave;s version of the formula.

You did ask in your thread title about using absolute cell reference, which is what I provided. Excel does not adjust absolute cell references when dragging the cell pointer or when copy such cells.

Just to be clear, here are example of absolute and relative cell references:

Relative: A1 = both column & row reference will adjust
Absolute: $A$1 = no adjustments to column or row reference



You can also have mixed references:

Relative row, absolute column: $A1 = only the row reference adjusts
Absolute row, relative column: A$1 = only the column reference adjusts