View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Creator
 
Posts: n/a
Default ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)

The formula you typed contains an error.........no specifics
--
Creator


"bj" wrote:

what is the error?
if the equation were in cell A1, it should give the value in B2
what does it do?

"Creator" wrote:

Why does this formula give me an error?
=offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)


--
Creator'


"Creator" wrote:


--
Creator