#REF - means the error in the formula like non existing reference.
Ok here's another one..
I have this cell formula
=IF(AB11="","",IF(ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))),EPMMemberProperty("This_Model ",AB11,"ACCOUNT"),""))
I understand EPMMemberProperty("This_Model ",AB11,"ACCOUNT") returns the Account parameter value. But what is this bit below doing?
IF(ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))
Is it searching for #Error in the ACCOUNT parameter of the member housed in AB11?
Lucy
Add comment