I am trying to multiply the number of owned shares by the current price, however, I am getting the following error:
Function MULTIPLY parameter 2 expects number values. But 'OWNED SHARES' is a text and cannot be coerced to a number.
| SYMBOL | OWNED SHARES | SHARES PRICE |
|---|---|---|
| ABML | 100 | 0,5 |
| BABA | 100 | 100 |
Function is
={"SHARES PRICE";BYROW(A2:A, LAMBDA(r, IF(r="",,GOOGLEFINANCE(r, "price")*B:B)))}
I tried *B2:B but it does not work.
Excel demo:
