Now what if I wanted some text that wasn't a hyperlink to appear if false. For example: IF(a4="G",Hyperlink("http://google.com","Google"),"No Link")

What is strange is that once there's the hyperlink function in there, even if that condition is not chose, the cell is formatted as a hyperlink.

Thanks!

PS -- the function is more complicated than above; I just simplified it down to the most basic components relevant to the issue at hand