View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default 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