Hello,
In the first cell, everything goes in, and in the second cell, I get an error.
"Parameter 1 of the MINUS function parameter requires a number." 0.352777 "is text and cannot be changed to a number.
I have tried to change regional setting for GB, next for US but that wasn't working. Im from Poland.
I import data. C2 is =IMPORTDATA("https://cryptoprices.cc/BTC/")
D2 is working I mean =(C2-B2)/B2
But next cell not idk why
I think it's something related to a period / comma in a number. How to get it to calculate correctly.
please help
Thx
In the first cell, everything goes in, and in the second cell, I get an error.
"Parameter 1 of the MINUS function parameter requires a number." 0.352777 "is text and cannot be changed to a number.
I have tried to change regional setting for GB, next for US but that wasn't working. Im from Poland.
I import data. C2 is =IMPORTDATA("https://cryptoprices.cc/BTC/")
D2 is working I mean =(C2-B2)/B2
But next cell not idk why
I think it's something related to a period / comma in a number. How to get it to calculate correctly.
please help
Thx
![smile.gif](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fimages%2Fsmilies%2Fsmile.gif&hash=06dc9e464d33d412e75f3af24c359e79)