Copying a formula with multiple worksheets down rows and across co
 

I have the following formula:=IF('LC + CC'!B3="","",'LC + CC'!B3+'LC +
CC'!B3*F69+'Sales Price (2)'!B3*'Sales Price'!F70+'Sales Price (2)'!B3*'Sales
Price'!F71+'Sales Price (2)'!B3*'Land Cost'!B14)

Im trying to copy this down multiple rows as follows:=IF('LC +
CC'!B4="","",'LC + CC'!B4+'LC + CC'!B4*F69+'Sales Price (2)'!B4*'Sales
Price'!F70+'Sales Price (2)'!B4*'Sales Price'!F71+'Sales Price (2)'!B4*'Land
Cost'!B14)

Im also trying to copy across multiple columns as follows:=IF('LC +
CC'!C3="","",'LC + CC'!C3+'LC + CC'!C3*F69+'Sales Price (2)'!C3*'Sales
Price'!F70+'Sales Price (2)'!C3*'Sales Price'!F71+'Sales Price (2)'!C3*'Land
Cost'!B14)

Each time I try it Changes all of the formula. Any help is much appreciated:)

Copying a formula with multiple worksheets down rows and across co
 

Hi!

If you copy '=A1' into the next row it will show '=A2'.

To stop that happening;

Go to the original cell;

Press F2 (the function button at the top row on your keyboard);

Move your cursor right after '=' but before 'A';

Now press F4(the function button);

You will see your formula changed as '=$A$1';

Now copy that to the next row;

You will see your formula remains as '=$A$1';

There if you want to keep your formulae or part of the formulae unchanged
have the $ sign in front of the cell references;

f you want to keep your formulae or part of the formulae changed do not have
the $ sign in front of the cell references;

Within aong formule like the one you have you can apply both.


"Rookie" wrote:

I have the following formula:=IF('LC + CC'!B3="","",'LC + CC'!B3+'LC +
CC'!B3*F69+'Sales Price (2)'!B3*'Sales Price'!F70+'Sales Price (2)'!B3*'Sales
Price'!F71+'Sales Price (2)'!B3*'Land Cost'!B14)

Im trying to copy this down multiple rows as follows:=IF('LC +
CC'!B4="","",'LC + CC'!B4+'LC + CC'!B4*F69+'Sales Price (2)'!B4*'Sales
Price'!F70+'Sales Price (2)'!B4*'Sales Price'!F71+'Sales Price (2)'!B4*'Land
Cost'!B14)

Im also trying to copy across multiple columns as follows:=IF('LC +
CC'!C3="","",'LC + CC'!C3+'LC + CC'!C3*F69+'Sales Price (2)'!C3*'Sales
Price'!F70+'Sales Price (2)'!C3*'Sales Price'!F71+'Sales Price (2)'!C3*'Land
Cost'!B14)

Each time I try it Changes all of the formula. Any help is much appreciated:)