| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adress formula nested in an IF...
Hi
I´ve made an adress formula in an IF, to return the valeu of that same cell but in Sheet2. It doesn´t work! the if formula doesn´t interpert the return of the adress formula as an excel "range". Can anyone help me? Thanks Speed =IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"") A1 =Sheet2! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adress formula nested in an IF...
-----Original Message----- Hi I´ve made an adress formula in an IF, to return the valeu of that same cell but in Sheet2. It doesn´t work! the if formula doesn´t interpert the return of the adress formula as an excel "range". Speed Without the error checking =INDIRECT(A7&ADDRESS(ROW(),COLUMN())) seems to work. Regards Peter |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adress formula nested in an IF...
You received an answer to your original question. Why not check it out.
-- Regards, Tom Ogilvy "SpeeD72" wrote in message ... Hi I´ve made an adress formula in an IF, to return the valeu of that same cell but in Sheet2. It doesn´t work! the if formula doesn´t interpert the return of the adress formula as an excel "range". Can anyone help me? Thanks Speed =IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"") A1 =Sheet2! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula for Single Cell Adress | Excel Worksheet Functions | |||
| Can Excel Adress Envelopes? | Excel Worksheet Functions | |||
| SUM using results from an Adress-formula | Excel Discussion (Misc queries) | |||
| How can I get the domain name out a email adress? | Excel Worksheet Functions | |||
| Find value and adress | Excel Programming | |||
Hybrid Mode
