Adding logical function to Indirect formula

[howard]

I have the following indirect formula

 =INDIRECT("'"&$A2&"'!B12")

I want to amend this formula that if B12 on sheet the sheet contained in A2 in the formula contains text, then it must return 0, otherwise the value in B12 on the sheet

for eg if B12 on sheet BRsales is "Sales data not available" i.e this is text , then 0 to be returned, otherwise the value


Your assistance is most appreciated

 

[wideboydixon]

Try wrapping the N() function around it like this:

=N(INDIRECT("'"&$A2&"'!B12"))

WBD

 

[Norie]

Try this.

=IFERROR(INDIRECT("'"&$A2&"'!B12")+0, 0)

 

[howard]

Thanks for the help