Kamis, 08 September 2011

Messages In This Digest (2 Messages)

Messages

1a.: Return 0 instead of error

Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg

Thu Sep 8, 2011 1:26 am (PDT)

Hi,

I have one formula below.

=RCHGetTableCell("http://investing.businessweek.com/businessweek/research/stocks/financials/financials.asp?ticker="&$C$8&"&dataset=incomeStatement&period=A&currency=US%20Dollar",1,">interest expense")

Sometimes , Interest Expense does not exist in the statement. So the formula would return "Error".

How do I modify it so that it can return "0" instead?

Best regards,

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: Return 0 instead of error

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu Sep 8, 2011 1:31 am (PDT)

Check the documentation. One of the parameters determines what to return for
an error, but defaults to a value of "Error".

On Thu, Sep 8, 2011 at 1:26 AM, wu_ming_sg <nghongchong@hotmail.com> wrote:

>
> I have one formula below.
>
> =RCHGetTableCell("
> http://investing.businessweek.com/businessweek/research/stocks/financials/financials.asp?ticker="&$C$8&"&dataset=incomeStatement&period=A&currency=US%20Dollar",1,">interest
> expense")
>
> Sometimes , Interest Expense does not exist in the statement. So the
> formula would return "Error".
>
> How do I modify it so that it can return "0" instead?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)