Help: Copying Downwards Formula

  • Thread starter Thread starter Jaime
  • Start date Start date
J

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
 
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.
 
Back
Top