| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
-- Creator |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
Why does this formula give me an error?
=offset(ADDRESS(ROW(),COLUMN()),1,1,1,1) -- Creator' "Creator" wrote: -- Creator |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
???? =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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
