Avoid HYPERLINK formula when arguments are empty or with error

[drom]

Hi! and Thanks in advance

I am trying to use the following Formula:

=IFERROR(IF(OR(B2="";B4="");"Load the invoice's PDF image";HYPERLINK(B2;B4));"Load the invoice's PDF image")

My problem comes when B2 and/or B4 are empty

• The hyperlink still exists

So you can Click it (the Hyperlink), despite The link goes anywhere

Is there any way to avoid this

ps:
On B2 is the Link_Location, I will put the PDF file's fullname through a Macro (No problem)
On B4 I will put the Friendly_name of the invoice, Kind of Invoice_0001ABC

 

[Special-K99]

You need to check if there is an error in B2 or B4 BEFORE checking their content.

Something close to...
=IF(ISERROR(B2),"Load...",IF(B2="","Load...",IF(ISERROR(B4),"Load...",IF(B4="","Load...",HYPERLINK(B2,B4)))))