HYPERLINK within an IF function.

Hiya,

Hope you're all having a lovely evening.

I'm I wrong in presuming you can still use the HYPERLINK function within and IF function?

Cell A1 says:

=IF('Course Overview'!A2="",(HYPERLINK("www."&A4&".com","Click here")),'Course Overview'!A2)

If I click the 'Fx' button, I can see that each section of this formula does work. If 'Course Overview'!A2="", the hyperlink appears as normal. But if I click the hyperlink, a box pops up and it says 'Cannot open the specified file'.

Been playing around for ages and can't get it to work.

Any help is much appreciated. Thanks,

Try this:

=IF('Course Overview'!A2="",(HYPERLINK("http://www."&A4&".com","Click here")),'Course Overview'!A2)

Thanks, that's got it.