???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)

--
Creator

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


--
Creator'


"Creator" wrote:

>
> --
> Creator

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

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

Hey bj, thanks....it worked!!
--
Creator


"bj" wrote:

> the address function gives a text response not a referense response
> try
> =OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,1,1,1)
>
> "Creator" wrote:
>
> > 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

the address function gives a text response not a referense response
try
=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,1,1,1)

"Creator" wrote:

> 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