I am trying to create a hyperlink formula but i am having issues. what i currently have is =IF(L10="",HYPERLINK(Setup!$B$3&$C10&".zip"),IF(L10>" ",HYPERLINK(Setup!$B$4&$L10))).
so what i am trying to do is if cell L10 has text in it go the the first link and if L10 is blank go to the second link.
in C10 i have a name, or rather the first part of the name for a zip file.
any help would be appreciated.