Formulas in a range of cells
 

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?

Formulas in a range of cells
 

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?

Formulas in a range of cells
 

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?

Formulas in a range of cells
 

=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?

Formulas in a range of cells
 

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?

Formulas in a range of cells
 

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?