Limited autoformatting when pasting

F

Flaxkrax

Trying to find a timesaving operation, help needed.

I.E. a formula like this;

IF(LEFT(SheetA.A1,1)="X",(SheetB.B1*SheetC.C1),T(""))

Now using this formula in Sheet D, I want the Table A value to remain
fixed and the B&C values move along as I copy it down rows or columns.
On row zz it should look like this;
IF(LEFT(SheetA.A1,1)="X",(SheetB.Bzz*SheetC.Czz),T(""))

Help!

//Johan
 
S

Stefi

Hi Flaxkrax,
Try this:
IF(LEFT(SheetA!$A$1,1)="X",(SheetB!$B1*SheetC!$C1),T(""))

Regards,
Stefi


„Flaxkrax†ezt írta:
 
Top