I am trying to select a range of cells exp. (C15 - C25) and I will for sure
be entering data in C15. It varies if I will use all the cells up to C25. Now
is C26 I want a formula that take the last entered cell in that data range
and subtracts it from cell C15. Is that possible to do?

What if C15 is the only entry? I'm assuming that you don't want anything to
happen if C15 is the only entry.

=IF(COUNT(C15:C25)<2,"",C15-LOOKUP(10^10,C16:C25))

Biff

"lmc" <u30700@uwe wrote in message news:6bcb170ae5bfc@uwe...
I am trying to select a range of cells exp. (C15 - C25) and I will for
sure
be entering data in C15. It varies if I will use all the cells up to C25.
Now
is C26 I want a formula that take the last entered cell in that data range
and subtracts it from cell C15. Is that possible to do?

Let me get this straight.

You enter numbers in columns C from cell C15 up to some random spot
that will never be past C25.

Example:
C
15. 12
16. 10
17.
18.
19. 5
20.
21. 2
22. 3
23.
24.
25.

In this case you would want C26 to be 12 - 3 = 9.

But if data was only entered in C15 = 12, C16 = 2 then C26 = 12-2 = 10.

What about if only C15 = 5 is entered? Does C26 = 5?

IF you're logic is the same as mine, the this should work. Put this in
C26.

=IF(COUNT(C16:C25)0,C15 - LOOKUP(2,1/(C16:C25<""),C16:C25),C15)

Cheers,
Jason Lepack

lmc wrote:
I am trying to select a range of cells exp. (C15 - C25) and I will for sure
be entering data in C15. It varies if I will use all the cells up to C25. Now
is C26 I want a formula that take the last entered cell in that data range
and subtracts it from cell C15. Is that possible to do?

=C15-LOOKUP(2,1/(C15:C65536<""),C15:C65536)


"lmc" wrote:

I am trying to select a range of cells exp. (C15 - C25) and I will for sure
be entering data in C15. It varies if I will use all the cells up to C25. Now
is C26 I want a formula that take the last entered cell in that data range
and subtracts it from cell C15. Is that possible to do?

Biff

Very good.

Gord

On Thu, 4 Jan 2007 14:55:50 -0500, "T. Valko" wrote:

What if C15 is the only entry? I'm assuming that you don't want anything to
happen if C15 is the only entry.

=IF(COUNT(C15:C25)<2,"",C15-LOOKUP(10^10,C16:C25))

Biff

"lmc" <u30700@uwe wrote in message news:6bcb170ae5bfc@uwe...
I am trying to select a range of cells exp. (C15 - C25) and I will for
sure
be entering data in C15. It varies if I will use all the cells up to C25.
Now
is C26 I want a formula that take the last entered cell in that data range
and subtracts it from cell C15. Is that possible to do?

Thank you!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Biff

Very good.

Gord

On Thu, 4 Jan 2007 14:55:50 -0500, "T. Valko"
wrote:

What if C15 is the only entry? I'm assuming that you don't want anything
to
happen if C15 is the only entry.

=IF(COUNT(C15:C25)<2,"",C15-LOOKUP(10^10,C16:C25))

Biff

"lmc" <u30700@uwe wrote in message news:6bcb170ae5bfc@uwe...
I am trying to select a range of cells exp. (C15 - C25) and I will for
sure
be entering data in C15. It varies if I will use all the cells up to
C25.
Now
is C26 I want a formula that take the last entered cell in that data
range
and subtracts it from cell C15. Is that possible to do?