| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address in IF formula.. doens work..
Hi.
I´ve made the following formula but it doesn´t assume the values in the address formula..... why? =IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"") A1=Sheet2! Thanks a lot SpeeD |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Address in IF formula.. doens work..
Address returns a string. If you want to reference a cell with the result,
would use the result with indirect. If A1 contains Sheet2!, it should only contain Sheet2 with out an exclamation point =if(Indirect(Address(row(),Column(),,,A1)) < "", column(),"") Change the , to ; if that is your regional list separator. -- Regards, Tom Ogilvy "SpeeD72" wrote in message ... Hi. I´ve made the following formula but it doesn´t assume the values in the address formula..... why? =IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"") A1=Sheet2! Thanks a lot SpeeD |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Address in IF formula.. doens work..
What are you trying to do? Even if you change your semicolons to
commas, the test will always evaluate as true. SpeeD72 wrote: Hi. I´ve made the following formula but it doesn´t assume the values in the address formula..... why? =IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"") A1=Sheet2! Thanks a lot SpeeD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink to server address does not work after save | Links and Linking in Excel | |||
| Why won't ADDRESS work nested inside SUMIF? | Excel Discussion (Misc queries) | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| email address links doesn't work on some cells?????? | Excel Discussion (Misc queries) | |||
| How do I create a name/address/phone 3-column list from Excel work | Excel Discussion (Misc queries) | |||
Hybrid Mode
