Need formula for a fixed cell minus last entry on ongoing log
 

Hi all - I need a formula so that I get the difference between the first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari

Hi Mari

Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
copy down as far as you want to go. You will then always subtract the last
entry from the first one, so that in D20, the formula will subtract C20 from
C2.

However, if you want the difference between the last 2 entries every time,
then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
the formula will subtract C20 from C19.

"Mari C" wrote:

Hi all - I need a formula so that I get the difference between the first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari

Hi!

First entry in A1.

Last entry in An

=A1-LOOKUP(9.99999999E+307,A:A)

Biff

"Mari C" <Mari wrote in message
...
Hi all - I need a formula so that I get the difference between the first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari

Thanks biff - after I limited the size of the column I was able to enter it
in the bottom of the column
Mari

"Biff" wrote:

Hi!

First entry in A1.

Last entry in An

=A1-LOOKUP(9.99999999E+307,A:A)

Biff

"Mari C" <Mari wrote in message
...
Hi all - I need a formula so that I get the difference between the first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari

Hi Kassie

I needed to enter 20 columns so I wanted the sum at the bottom of the column
- biffs formula worked better for the layout of the page but yours was great
too. thanks a bunch

"Kassie" wrote:

Hi Mari

Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
copy down as far as you want to go. You will then always subtract the last
entry from the first one, so that in D20, the formula will subtract C20 from
C2.

However, if you want the difference between the last 2 entries every time,
then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
the formula will subtract C20 from C19.

"Mari C" wrote:

Hi all - I need a formula so that I get the difference between the first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari

You're welcome. Thanks for the feedback!

Biff

"Mari C" wrote in message
...
Thanks biff - after I limited the size of the column I was able to enter
it
in the bottom of the column
Mari

"Biff" wrote:

Hi!

First entry in A1.

Last entry in An

=A1-LOOKUP(9.99999999E+307,A:A)

Biff

"Mari C" <Mari wrote in message
...
Hi all - I need a formula so that I get the difference between the
first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari