Want blank cell displayed if indirectly referenced value is zero

[Pierre]

Using the following formula. (located in B17)


=IF(B4="","",(INDIRECT("'"&B$4&"'!$n$44")))

My question is: how to return a blank cell in B17, if N44 (on the
referenced tab) is a zero?
N44 and B17 are both formatted as percentages. B17 needs to stay as
an INDIRECT formula.

CF somehow misses on this one, and has no effect.

ideas?
Thanks.
Pierre

 

[Sandy Mann]

Just add it in:

=IF(B4="","",IF(INDIRECT("'"&B$4&"'!$n$44")="","",INDIRECT("'"&B$4&"'!$n$44")))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[PCLIVE]

Perhaps one way:

=IF(B4="","",IF(INDIRECT("'"&B$4&"'!$n$44")="","",INDIRECT("'"&B$4&"'!$n$44")))

HTH,
Paul

 

[Pierre]

Perhaps one way:

=IF(B4="","",IF(INDIRECT("'"&B$4&"'!$n$44")="","",INDIRECT("'"&B$4&"'!$n$44­")))

HTH,
Paul

--








- Show quoted text -

Thank you all. Works just fine.

Pierre