Thread: Want blank cell displayed if indirectly referenced value is zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
  
Posts: 193
Default 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
Reply With QuoteReply With Quote