Hey guys, if I want to reference the same source cell when copying a formula
(11% is the fuel sur-charge I want to reference in my calculation), how do I
do that without manually typing the source cell in each new cell?

I tried dragging the formula, but if the first cell is =d20*a10, when I drag
it the next cell is =e20*b10. I want =e20*a10, =f20*a10, etc.

Thanks

Take a look at the "difference between relative and absolute references"
topic in XL Help.

For example:

=D20 * $A$10


In article ,
Tugger wrote:

Hey guys, if I want to reference the same source cell when copying a formula
(11% is the fuel sur-charge I want to reference in my calculation), how do I
do that without manually typing the source cell in each new cell?

I tried dragging the formula, but if the first cell is =d20*a10, when I drag
it the next cell is =e20*b10. I want =e20*a10, =f20*a10, etc.

Thanks

Thank you!

"JE McGimpsey" wrote:

Take a look at the "difference between relative and absolute references"
topic in XL Help.

For example:

=D20 * $A$10


In article ,
Tugger wrote:

Hey guys, if I want to reference the same source cell when copying a formula
(11% is the fuel sur-charge I want to reference in my calculation), how do I
do that without manually typing the source cell in each new cell?

I tried dragging the formula, but if the first cell is =d20*a10, when I drag
it the next cell is =e20*b10. I want =e20*a10, =f20*a10, etc.

Thanks

you may want to name your cells. you could name the one row as Amount
and name the cell that has the 11% sur-charge as Tax
(Insert/Name/Define). That way the reference won't change when you
copy it, and if you look at the formula it will make some sense instead
of f3*$A$1, you would see Amount * Tax

Right on Chris! Man this is great stuff!

"Chris Rogers" wrote:

you may want to name your cells. you could name the one row as Amount
and name the cell that has the 11% sur-charge as Tax
(Insert/Name/Define). That way the reference won't change when you
copy it, and if you look at the formula it will make some sense instead
of f3*$A$1, you would see Amount * Tax