IF statement in Excel

shaypastakia | 17:55 Wed 10th Mar 2010 | Computers

2 Answers

I really need Excel to either open a file or show a hyperlink to a file when I use an IF statement and it returns true. Please help me!!

☺☻☺☻

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by shaypastakia. Once a best answer has been selected, it will be shown here.

Don't have excel to hand, but something like:

IF(A3=B3,Hyperlink("C:\test\namelist.doc","Li
st
of Names"),"")

Not sure why If got split onto 3 lines - it's all one line

1 to 2 of 2

Do you know the answer?