Stock Web Query Results - Formula

[normanbox]

I need help. I am running a simple web query: https://finance.yahoo.com/q/cf?s=AAC. The query return the cash flow statement for the stock symbol AAC. The query accurately gives me the cash flow statement, but places a dash “-“ for all zeros. The dash is accurate when compared to the actual web page; however, the dash is preventing me from completing any formulas when it’s referenced. For example, for the above web query, if I simply want to subtract “Total Cash Flows From Investing Activities”, which is -23,000, from Dividends Paid, which is “-“, the formula should result in -$23,000, but instead I get the “#Value!” error.

I’ve tried using an if statement to replace the dash, but I can’t seem to get it to work.

Any help is very much appreciated.

 

[DRSteele]

Your IF statement in the calculation should look like this IF(c28="- ",0,c28) What I've typed there between the quotes is a dash with two spaces.

 

[normanbox]

That works perfectly! Thank you very much.