• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

Hyperlink formula

Can someone help with this formula?
=HYPERLINK(TEXT(CELL("address",'Income Statement'!D108),""),TEXT(G14,""))
Thanks
0
Jenedge73
Asked:
Jenedge73
1 Solution
 
NBVCCommented:
Try:

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

although not sure you need the TEXT() functions.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now