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

  • Thread starter Thread starter Billznik
  • Start date Start date
B

Billznik

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

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