Solved: IF THEN COMMANDS??

[Tenspeed39355]

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

[Bob Phillips]

=IF(xlqprice(A3)=0,DY1,xlqprice(A3))

[NukedWhale]

Beat me to it xld

[Tenspeed39355]

You hit that one on the head. The formula works like a charm
Thanks for your help.
Max

[Tenspeed39355]

I will close the thread and give a rating
Max