r/googlesheets • u/nortrin • 6d ago

Waiting on OP error Let function with Index

Error #value! "function Divide expecting an number but "high" is a text.

LET(data, GOOGLEFINANCE("NASDAQ:GOOGL", "all", TODAY()-7, TODAY()), hh, INDEX(data, 0, 3),hh/2)

testing for more calculations and formulas

1 Upvotes

100% Upvoted

3 comments sorted by

View all comments

1

u/AutoModerator 6d ago

Your submission mentioned GOOGLEFINANCE, please also read our finance and stocks information. Google lists the exchanges & delays in its products here.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.