4 New Messages
Digest #2654
1b
Re: Getting "Error" value and want to have it show as a zero value by "Randy Harmelink" rharmelink
Messages
Wed Jun 12, 2013 7:47 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I need assistance with the IFERROR formula. In the table below I have hidden
columns not needed for this formula.
I look at the Excel help but still can't figure out the correct formula.
What I want to do is have a zero value in place of the Error value that is
the result of the IF statement shown in Column A Row 5
I hope I have provide enough information to allow you to understand what I
am trying to do.
Column
A
B
F
O
1
11
Element#
19
1
per
per
Error
IFERROR(IF($B4=$F4,(smfGetTagContent("http://dividata.com/stock/ "&$F4&"/divi
dend","p",O$3,">Ex-Dividend Date"))," "),"0")
columns not needed for this formula.
I look at the Excel help but still can't figure out the correct formula.
What I want to do is have a zero value in place of the Error value that is
the result of the IF statement shown in Column A Row 5
I hope I have provide enough information to allow you to understand what I
am trying to do.
Column
A
B
F
O
1
11
Element#
19
1
per
per
Error
IFERROR(IF($
dend","
Wed Jun 12, 2013 1:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
In such situations, I usually divide an expected value by 1. If it's
numeric, the value stays the same. If not, it triggers an error.
For example, for the date and amount, I would do something like:
=IFERROR(DATEVALUE(smfGetTagContent("http://dividata.com/stock/ "&$F4&"/dividend","p",500,">Ex-Dividend
Date"))/1,"--")
=IFERROR(smfGetTagContent("http://dividata.com/stock/ "&$F4&"/dividend","p",501,">Ex-Dividend
Date")/1,0)
On Wed, Jun 12, 2013 at 7:47 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> I need assistance with the IFERROR formula. In the table below I have
> hidden columns not needed for this formula. ****
>
> I look at the Excel help but still can't figure out the correct formula. *
> ***
>
> ** **
>
> What I want to do is have a zero value in place of the Error value that is
> the result of the IF statement shown in Column A Row 5 ****
>
> ** **
>
> I hope I have provide enough information to allow you to understand what I
> am trying to do. ****
>
> ** **
>
> ** **
>
> *Column*
>
> *A*
>
> *B*
>
> *F*
>
> *O*
>
> *1*
>
> *11*
>
> Element#****
>
> *19*
>
> 1****
>
> *per*
>
> per****
>
> Error****
>
> IFERROR(IF($B4=$F4,(smfGetTagContent("http://dividata.com/stock/ "&$F4&"/dividend","p",O$3,">Ex-Dividend
> Date"))," "),"0")****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ** **
>
>
numeric, the value stays the same. If not, it triggers an error.
For example, for the date and amount, I would do something like:
=IFERROR(DATEVALUE(
Date"))
=IFERROR(smfGetTagC
Date")/
On Wed, Jun 12, 2013 at 7:47 AM, Kermit W. Prather
<kermitp@tampabay.
>
> I need assistance with the IFERROR formula. In the table below I have
> hidden columns not needed for this formula. ****
>
> I look at the Excel help but still can't figure out the correct formula. *
> ***
>
> ** **
>
> What I want to do is have a zero value in place of the Error value that is
> the result of the IF statement shown in Column A Row 5 ****
>
> ** **
>
> I hope I have provide enough information to allow you to understand what I
> am trying to do. ****
>
> ** **
>
> ** **
>
> *Column*
>
> *A*
>
> *B*
>
> *F*
>
> *O*
>
> *1*
>
> *11*
>
> Element#****
>
> *19*
>
> 1****
>
> *per*
>
> per****
>
> Error****
>
> IFERROR(IF($
> Date"))
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ** **
>
>
Wed Jun 12, 2013 7:18 pm (PDT) . Posted by:
"Jason" g3m1n1980
http://www.nasdaq.com/symbol/nus/guru-analysis/lynch
=RCHGetTableCell("http://www.nasdaq.com/symbol/ "&C1&"/guru-analysis/lynch",4,">Source",,,,1,"</table",,"--")
Im having issues with the gurus on the nasdaq site. It was working recently and i dont see anything has changed with the URL.
Please advise
=RCHGetTableCell(
Im having issues with the gurus on the nasdaq site. It was working recently and i dont see anything has changed with the URL.
Please advise
Wed Jun 12, 2013 7:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What are you trying to extract? With:
=RCHGetTableCell("http://www.nasdaq.com/symbol/nus/guru-analysis/lynch
",4,">Source",,,,1,"</table",,"--")
...I am getting back the 93% from Peter Lynch...
If that Guru Score is all you want, I would just pick it up further down,
with:
=smfConvertData(smfStrExtr(RCHGetTableCell("
http://www.nasdaq.com/symbol/nus/guru-analysis/lynch ",
0,"Guru Score:"),":","~"))
On Wed, Jun 12, 2013 at 7:18 PM, Jason <xxjaysonxx@aol.com > wrote:
> http://www.nasdaq.com/symbol/nus/guru-analysis/lynch
>
> =RCHGetTableCell("http://www.nasdaq.com/symbol/
> "&C1&"/guru-analysis/lynch",4,">Source",,,,1,"</table",,"--")
>
> Im having issues with the gurus on the nasdaq site. It was working
> recently and i dont see anything has changed with the URL.
>
> Please advise
>
=RCHGetTableCell(
",4,"
...I am getting back the 93% from Peter Lynch...
If that Guru Score is all you want, I would just pick it up further down,
with:
=smfConvertData(
http://www.nasdaq.
0,"Guru Score:"
On Wed, Jun 12, 2013 at 7:18 PM, Jason <xxjaysonxx@aol.
> http://www.nasdaq.
>
> =RCHGetTableCell(
> "&C1&"
>
> Im having issues with the gurus on the nasdaq site. It was working
> recently and i dont see anything has changed with the URL.
>
> Please advise
>
Tidak ada komentar:
Posting Komentar