Want blank cell displayed if indirectly referenced value is zero

  • Thread starter Thread starter Pierre
  • Start date Start date
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
 
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
 
Perhaps one way:

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

HTH,
Paul
 
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
 
Back
Top