Alright change that back. It looks like its being flagged because you're missing parentheses after JSON. Put one after JSON and then one after Headers"
You should just be able to copy and paste this into the cell
=VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))
can you reply with the api command?
Excuse me, I don't know what “api command” is :(
That's this
=VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))
Are you getting the #NAME error in the cell where you're trying to get the current price?
Here is a screen:
Can that help?
It looks like you're using semi colons instead of commas in those quotations right after USD.
Here is what I get with commas:
Alright change that back. It looks like its being flagged because you're missing parentheses after JSON. Put one after JSON and then one after Headers"
You should just be able to copy and paste this into the cell
=VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))
No, parentheses are OK. I suspect this version of Excel is pure garbage :(