Want blank cell displayed if indirectly referenced value is zero
 

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

Want blank cell displayed if indirectly referenced value is zero
 

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


Replace @mailinator.com with @tiscali.co.uk


"Pierre" wrote in message
...
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

Want blank cell displayed if indirectly referenced value is zero
 

Perhaps one way:

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

HTH,
Paul


--

"Pierre" wrote in message
...
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

Want blank cell displayed if indirectly referenced value is zero
 

On May 5, 2:37*pm, "PCLIVE" wrote:
Perhaps one way:

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

HTH,
Paul

--

"Pierre" wrote in message

...



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- Hide quoted text -

- Show quoted text -


Thank you all. Works just fine.

Pierre