drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 540
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
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
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
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
Last edited: