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.