Hyperlink formula

Can someone help with this formula?
=HYPERLINK(TEXT(CELL("address",'Income Statement'!D108),""),TEXT(G14,""))
Thanks
Jenedge73Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NBVCConnect With a Mentor Commented:
Try:

=HYPERLINK("#"&TEXT(CELL("address",'Income Statement'!D108),""),TEXT(G14,""))

although not sure you need the TEXT() functions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.