Forum Discussion
#SPILL! Error when doing simple calculation
but suffice to say I much prefer just to use a column, instead of a fixed field.I used to be able to do this in the past 10 years ...
The keyword is "new calculation engine". Either you adapt to this or you have to revert from Excel 365 to Excel 2019.
There is a third option for the formula which enforces implicit intersection: =@X:X+@I:I. And copy down.
Many thanks for your response. Sorry I dont quite know what "implicit intersection" is even googled, but suffice to say I much prefer just to use a column, instead of a fixed field.
I used to be able to do this in the past 10 years ...
but suffice to say I much prefer just to use a column, instead of a fixed field.I used to be able to do this in the past 10 years ...
The keyword is "new calculation engine". Either you adapt to this or you have to revert from Excel 365 to Excel 2019.
There is a third option for the formula which enforces implicit intersection: =@X:X+@I:I. And copy down.