Rich text field using URL

Good afternoon all.... I have created a formula that check for the existence of a file. The premise is that if no file exists, create text that says no record, or if it does create a 'URL LINK' to ...