Hi, thanks for replying!
Yep. I've read that and it was helpful for getting the proper link and text to appear.

All that is giving me trouble is the fact that the link is still appearing when it should not. My code is like this:

{HYPERLINK "{IF {Mergefield Variable}="Y" "http://www.google.com" ""}"}

So I only want the link to appear if the Variable=Y, and it does. But it is still appearing when the Variables !=Y. I'm guessing it has something to do with the IF being inside the Hyperlink and not outside, but I'm not sure how to work around that to get it to go away when Variable!=Y. I hope this makes sense.