Bit cumbersome, but seems to work.

=OFFSET(INDEX(Cash,1),ROW()-MIN(ROW(Cash))-1,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
oups.com...
Sigh, I'm drawing a blank....

E10:E30 evaluates to additional cash based on values in U10:U30.
Ostensibly, E11 is U11-U10; similarly for E12:E30.

I have named U10:U30 "Cash". So I want to write that formula in a
form similar to:

=Cash - offset(Cash,-1,0)

Or so I thought. The OFFSET(...) expression is wrong.

What is the correct expression for "the same row minus one in the
named range Cash"?

I am looking for a solution that is readable and self-documenting.