offset function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

This may be a very easy question. I am using the offset function to carry a running total on Column D, but how do i get the difference between two columns using the offset function

This is the running total function.
=offset(E3,-1,0)+D3

Thanks for your help

Chris
 
Hi Chris
why don't you use
E2+D3 instead of your OFFSET formula. Both will achieve the same?

For a difference betwenn two columns just use
=E3-D3

but maybe I'm missing something here :-)
Frank
 
Back
Top