How to calculate data which is from web query

[YavuzAkbay]

I got stock price data (Yahoo Finance) from web query. When I click refresh it changes theres no problem about that but problem is I cant include that data in my calculations. For example lets say I pulled Tesla price and I want to multiply that price with 5, when I try that it says result is 5. I tried =B2*5 and =Product neither them work. Can't I include them in my calculations?

 

[johnny51981]

Do you have a screenshot or sample file you can provide?

 

[YavuzAkbay]

Do you have a screenshot or sample file you can provide?

As you can see "Total" is Amount * Price so when I put price data myself it multiplies but when I get that price data which is as you can see in the SOL line and when I try to multiply that I get that result.

 

[johnny51981]

I think your SOL Price might actually be a text formatted population. So in your Total calculation, you may need to try something like =PRODUCT(G5,VALUE(H5))

 

[YavuzAkbay]

I think your SOL Price might actually be a text formatted population. So in your Total calculation, you may need to try something like =PRODUCT(G5,VALUE(H5))

I tried to turn data to value by making =VALUE(B1) first but it still says #VALUE!

 

[Domenic]

It looks like your version of Excel uses the comma as the decimal separator. If so, try 109,01 instead . . .

 

[YavuzAkbay]

It looks like your version of Excel uses the comma as the decimal separator. If so, try 109,01 instead . . .

I tried to change the format of the number but it still gives same error.

 

[Domenic]

Try changing the cell format first to either the General format, or Number format, or Currency format of your choice, and then re-enter the value 109,01. Does this help?

 

[YavuzAkbay]

Try changing the cell format first to either the Number format or Currency format of your choice, and then re-enter the value 109,01. Does this help?

Unfortunately that didn't work too.

 

[Domenic]

All things point to the value being recognized as a text value, instead of a numerical value . . .

1) The value in H5 is left-align instead of right-aligned within the cell.
2) The formula in I5 ignores the value in H5 and returns 1,74, instead of 189,68 (rounded to two decimal places).
3) The other formula in I4 returns the correct result.

So I'm surprised that my last suggestion did not work. Just to be sure that you're doing things right, try the following . . .

1) On the worksheet, select cell H5, which contains the value $109,01.
2) On the Ribbon, under the Home tab, in the Number group, select the Currency format.
3) Re-enter 109,01 in cell H5, and press ENTER.

Does this help?