Kiloelectronvolt
Board Regular
- Joined
- Oct 5, 2015
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
Hi Guys, I'm a novice so I'm trying to avoid using VBA. I currently have this hyperlink working well, but I was wondering if I could add one more line to it.
=HYPERLINK("path...\Job PO's 2021\PO "&A3263&"-signed.pdf",WORKDAY(J3263,5,))
IF L3263 is blank, use below path,
path...\Job PO's 2021\PO "&A3263&"-signed.pdf
BUT if L3263 has text, use:
path...\Job PO's 2021\PO "&A3263&".pdf
TIA
=HYPERLINK("path...\Job PO's 2021\PO "&A3263&"-signed.pdf",WORKDAY(J3263,5,))
IF L3263 is blank, use below path,
path...\Job PO's 2021\PO "&A3263&"-signed.pdf
BUT if L3263 has text, use:
path...\Job PO's 2021\PO "&A3263&".pdf
TIA