Help: Copying Downwards Formula

[Jaime]

Hi all,
I can't seem to be able to copy a formula downwards in a
col. I tried the drag down but it only copies the exact
figure and formula downwards.

My formula is simply:
=39*GST!$B$1

I want to be able to multiply a different figure with GST!
$B$1. I have tried using the copy and special paste,
formula.. but doesnt work too.

Using Excel 2002.

Thanks,
Jaime

 

[Harald Staff]

Hi Jaime

You want 39 to increase filling down while B1 stays absolute ? One way is

=ROW()*GST!$B$1
or
=(ROW()+38)*GST!$B$1

but the result depends on where the formula is, and it will change if you
insert/delete rows.