Sabtu, 17 Januari 2015

[smf_addin] Digest Number 3299

2 Messages

Digest #3299

Messages

Fri Jan 16, 2015 9:07 pm (PST) . Posted by:

ojalee1

Can someone help me out with this formula:


=RCHGetTableCell("http://www.gurufocus.com/stock/&Ticker",-1,"Traded in Other Countries")


I know it has something to do with the concatenate because the formula works and returns the Business Description when I use:


=RCHGetTableCell("http://www.gurufocus.com/stock/MMM",-1,"Traded in Other Countries")


Thanks in advance.

Fri Jan 16, 2015 9:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You aren't concatenating there. You just have a single string. The
ampersand operator is what concatenates two strings, such as:

"http://www.gurufocus.com/stock/" & Ticker

On Fri, Jan 16, 2015 at 10:07 PM, ojalee1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Can someone help me out with this formula:
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/&Ticker",-1,"Traded in
> Other Countries")
>
> I know it has something to do with the concatenate because the formula
> works and returns the Business Description when I use:
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/MMM",-1,"Traded in Other
> Countries")
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar