Conditional Hyperlinks

[csh]

I have a fairly simple problem, that I cannot see a way round.

I set up two cells:

B2: FALSE
B3: http://quiz.iplac.co.uk/

I then set up another cell to contain:

=IF(B2=TRUE, HYPERLINK(B3, "CGQ Quiz"), "No hyperlink")


Obviously, the behaviour I'm looking for is that if I set B2 to TRUE m
new cell will contain a hyperlink, otherwise it will just contain plai
text.

However, Excel shows the "No hyperlink" text as a hyperlink also and i
you click on it you get a pop-up saying "The address of the site is no
valid. Check the address and try again".

I have tried this on Excel 97 and XP with the same results.

I don't want to use any macros/VBA code.

Any ideas

 

[Dave Peterson]

Maybe you could live with a partial solution:

=IF(B2=TRUE,HYPERLINK(B3,"CGQ Quiz"),
HYPERLINK("#"&CELL("address",C1),"No hyperlink"))
(one cell)

I used C1 as my formula cell. So when you click on it, you're right back where
you started.

You could even point at another cell that contains:
I SAID NO HYPERLINK!

(just to be irritating!)