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?