Thread
:
Updating data makes formula wrong
View Single Post
#
4
Posted to microsoft.public.excel.misc
vezerid
Posts: n/a
Updating data makes formula wrong
One way your formulas in column B:B will not be affected by
insertions/deletions which you do not possibly control: In B1:
=OFFSET(B1;0;-1)*0,25
And you can copy down as far as necessary.
HTH
Kostis Vezerides
Reply With Quote