TerryJ wrote:
>
>
> Hylton Conacher(ZR1HPC) wrote:
>> TerryJ wrote:
>>>
>>> Calc is behaving normally and appropriately. This requires a simple
>>> amendment of the formulas. The sheet references in the formulas should
>>> be
>>> absolute, not relative.
>> I do not understand the difference between a relative and an absolute
>> formula. Can you give an example of a relative formula and then the same
>> formula in absolute syntax?
>>
>> Please indicate where on the spreadsheet there are relative formulae and
>> what the syntax would be to correct them to absolute formulae.
>>
>> Tnx
>> Hylton
>>
>>
>
> This is the example you gave:
>
> - - - - - quote - - - - -
> The formula for E3 as per the master is =SUM((Totals.B5-D2))/(31-0) yet the
> formula in E3 in April Month is =SUM(('Monthly usage'.B5-D2))/(31-0)
> - - - end quote - - -
>
> What you need to do is insert a $ before the sheet name so that the above
> formula reads:
> =SUM(($Totals.B5-D2))/(31-0) . If you do that, the sheet name will not
> change when you copy the formula to another sheet.
>
> You can change references to various shades of absolute and relative with a
> keyboard shortcut (by default SHIFT+F4, not now working on my system for
> some unknown reason). Look in the Help index under "absolute addresses in
> spreadsheets".
Tnx Terry.
The & solved the main problem of cell sheet references changing. I have
identified another issue which I wil start a new thread for.
Rgards
Hylton
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
