View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JJ
 
Posts: n/a
Default =OFFSET(cell("address"),-1,0)

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)