Thread: offset function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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