| 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! |
| 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 | |||
Threaded Mode
