Tenspeed39355
06-10-2008, 06:56 AM
Good morning guys. I am using a program named XLQ. This program looks over in yahoo and brings back the price for the symbol indecated.
Example: =xlqprice(A3) A3 is the cell containing the symbol.
There are times that the symbol is not on Yahoo and XLQ will return a 0.
I have the price in my ss. What I am after is if XLQ returns a 0 then I want the price in my ss to show in place of the 0. To explain further the
price is in DY1. Hope this make sense.
Max
Example: =xlqprice(A3) A3 is the cell containing the symbol.
There are times that the symbol is not on Yahoo and XLQ will return a 0.
I have the price in my ss. What I am after is if XLQ returns a 0 then I want the price in my ss to show in place of the 0. To explain further the
price is in DY1. Hope this make sense.
Max