View Single Post
 
Old 04-06-2017, 09:06 AM
Harleygal17 Harleygal17 is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2017
Posts: 3
Harleygal17 is on a distinguished road
Question Add external hyperlink to a calculated number

I am trying to add a hyperlink (any hyperlink external to data on the spreadsheet) in a cell that has a formula for a calculated number. For instance, something as simple as =B4*C4. When the number is displayed I want to be able to add a hyperlink to some external content so the user can look at the details from another system.

For purposes of my example, if the calculated number is "5" (formatted as number), I want it (5) to appear as a hyperlink and take me to: https://www.msofficeforums.com.

I've tried a few simple things and searched the web but haven't found anything that seemed applicable. Any ideas from anyone?

FYI: I am using Excel 2016.

Last edited by Harleygal17; 04-06-2017 at 09:08 AM. Reason: Added Excel version.
Reply With Quote