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

Using if function to show blank when cell in other sheet is empty
 

how about if you use
=IF(Calculator!C44 = "","",HYPERLINK("mailto:"&Calculator!C44))


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

Using if function to show blank when cell in other sheet is empty
 

Great, that did it, thanks.


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