Everything Harlan said and...
Why not, if you're in cell H5, make a formula that says =H4
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"JJ" wrote:

What is wrong with this? I want to be able to place this formula anywhere in
a spreadsheet and have it return the cell above it. Thanks!

=OFFSET(cell("address"),-1,0)