reference in stock function
Hi,
I am trying to use the function "stock".
it takes 2 arguments. it works ok when i hard code these 2 arguments
like =STOCK("MSFT"; "PRICE")
but when i do cell reference, it doesn't work
=STOCK(A2;B1);
my cells looks like this
symbol price
MSFT =STOCK(A2;B1)
is the syntax wrong or is it not supported?
any other work around?
thanks
Sasi