can you dislplay a hyperlink as an answer?

[Omegaman2]

I need a spreadsheet that produces an output with a hyperink. All the formulae are worked out, it is a logical with AND condition, when both conditions are met, I need to return a clickable url, not merely a text to be copied into a browser's adrees bar, is that doable? By the way, ideally, if the conditions are false, I want to diplay text that is NOT a hyperlink, if true dispaly a hyperlink.

Not idea but acceptable, i can return a hyperlink if true, and nothing if false.

Any ideas?

Thaks in advance

here is the formula in the cell in question:

=IF(AND(A3="test",E3<=101),"http://google.com","Data entered in the above cells is incorrect")

[martindwilson]

you could try
=IF(AND(A3="test",E3<=101),HYPERLINK("http://google.com","google"),"Data entered in the above cells is incorrect")
then to make it look like a hyperlink as at the moment although it says google and is clickable itys not obvious
conditional format as cell value ="whatever your friendly name is" in this case ="google"
chose blue font and underscore

[Omegaman2]

Thanks so much, this worked fine. I din't try making the link blue and underlined, I just made my friendly name "Click Here", good enough for my purposes. I did have an issue where Excel told me my link was invalid (or something to that effect). The URL was to a subdomain, but when I pointed it to the main domain it worked fine. Later, i specified a subdomain and it worked, maybe I had a comma instead of a period or some other sort of typo or syntax error that I missed, I don't know. Anyway, thanks again.