Solved

Hyperlink formula

Posted on 2013-11-08
1
241 Views
Last Modified: 2013-11-14
Can someone help with this formula?
=HYPERLINK(TEXT(CELL("address",'Income Statement'!D108),""),TEXT(G14,""))
Thanks
0
Comment
Question by:Jenedge73
1 Comment
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39634369
Try:

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

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

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question