Thread: Using if function to show blank when cell in other sheet is empty
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billznik Billznik is offline
external usenet poster
  
Posts: 1
Default Using if function to show blank when cell in other sheet is empty

I want an email list that I have in worksheet "calculator" to
automatically update on all of my other sheets when I add new emails to
the list, but I want the cells to display nothing when they are empty. I
can't seem to get the if formula right. The formula below works, but
displays the "mailto:" when the cell is empty, how can I get rid of
that?

=HYPERLINK("mailto:"&Calculator!C44)


--
Billznik
------------------------------------------------------------------------
Billznik's Profile: http://www.excelforum.com/member.php...o&userid=37119
View this thread: http://www.excelforum.com/showthread...hreadid=569727

Reply With QuoteReply With Quote