Excel: How do I display specified text instead of the value?

Within Excel, I want to indicate some text as an alternative to the actual value and also hyperlink.

The key reason why is because Relating to made Exceed generate the hyperlink dependant on certain conditions, and if it is just a link rather than showing your entire code within the cell it would be nicer when it looks like a option by saying “SEND EMAIL”.

Can anybody help

Hyperlink might add your friendly name following on from the link easily add any coma then insert pleasant name.
give a full example recommendations something from probably my textbooks.

=IF(ISBLANK(C7), “”, HYPERLINK
(“..\”&C7&”.xlsm”, “New Book”))
C7 represents the brand new book name but is not in connection format.So if C7 will be blank that shows practically nothing “”, otherwise the item puts in the hyperlink implementing New Book because friendly title.

=if(condition, “SEND EMAIL”).