How to google sheets hyperlink 'cell text' as formula-CodePudding

Home > Net > How to google sheets hyperlink 'cell text' as formula

How to google sheets hyperlink 'cell text' as formula

Time：01-22

Is it possible somehow to make a calculation in 'cell text' of Google sheets HYPERLINK formula? This is not working:

=HYPERLINK("link.com","52.70*1.5")

I have already checked the internet and on this website for any available solution, but didn't find anything similar...

CodePudding user response：

Just remove the double quotes to the label maybe

=HYPERLINK("link.com",52.7*1.5)

CodePudding user response：

Wow - that was quick - thanks a lot!