Donate SIGN UP

IF statement in Excel

Avatar Image
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!!

☺☻☺☻
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

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

For more on marking an answer as the "Best Answer", please visit our FAQ.
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 2rss feed

Do you know the answer?

IF statement in Excel

Answer Question >>