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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
How can I assign a value to a cell without putting a formula in it 4
Return blank cell if data cell is blank 4
CountIf previous cell formula 0
Formula refers to empty cells even when cells contains data 1
using the =page! feature to transpose a row to column 0
sheet name in cell that is used by other formulas 3
If function across sheets prints value of cell 4

Back
Top