Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
large function result as reference for offset function | Excel Discussion (Misc queries) | |||
XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
Offset Function | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
offset function | Excel Worksheet Functions |