offset function
 

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

offset function
 

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


CHRIS wrote:
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