Want blank cell displayed if indirectly referenced value is zero

P

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
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
P

PCLIVE

Perhaps one way:

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

HTH,
Paul
 
P

Pierre

Perhaps one way:

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

HTH,
Paul

--








- Show quoted text -
Click to expand...


Thank you all. Works just fine.

Pierre
 
Top