excel functions--hyperlink problem

  • Thread starter Thread starter sailesh
  • Start date Start date
S

sailesh

Hi,
Iam trying to use this formula
=IF((H4=5),HYPERLINK(KI!$D$6)), and also the cell in the KI link D6 i
a nother hyperlink referring to a webpage.

Is there a way in excel in which i can pull up the hyperlink in th
cell D6 of the KI sheet when i click on the cell which contains th
formula?

Really appriciate if someone could help me with this!
 
Hi Sailesh,

On my Excel 2003 spreadsheet, I have the following:

Cell A1 contains =IF(B1<5,HYPERLINK(C1,"hotmail"),"")
Cell B1 contains 1
Cell C1 contains http://www.hotmail.com

When I click on A1 it opens the hotmail website.

What is happening for you?

Cheers,
Katherine Coombs
 
Hi Katherine,

I have tried the fucntion you suggested and it gives me a erro
"cannot open specified file".

and also iam using a Excel 2000 spreadsheet dont know if this woul
make a difference.

Thanks for the interest shown! hope there is a solution to thi
problem.

Sailes
 
Back
Top