Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
looking for a formula | Excel Worksheet Functions |