I am trying to add a hyperlink to a cell which also has a formula. When I try the hyperlink wizard and add the range for the link and add the formula as the text it only takes the formula. Then I tried using the =hyperlink() function to link to the cell and that tries to use the text in the cell as a web address and gives me an error saying its an invalid address.
Sorry if this is somewhere else I’ve looked and couldn’t find it anywhere any help is appreciated Thanks