Minggu, 14 Agustus 2011

Messages In This Digest (2 Messages)

1a.: Re: =RCHGetElementNumber(B12,25) returns "error" if no symbol in "B1 From: Randy Harmelink
1b.: Re: =RCHGetElementNumber(B12,25) returns "error" if no symbol in "B1 From: Digger

Messages

1a.: Re: =RCHGetElementNumber(B12,25) returns "error" if no symbol in "B1

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

Sun Aug 14, 2011 2:39 am (PDT)

Normal EXCEL can handle that situation:

=IF(LEN(B12)=0,"--",RCHGetElementNumber(B12,25))

On Sun, Aug 14, 2011 at 1:55 AM, Digger <cavesinarizona@cox.net> wrote:

> the function =RCHGetElementNumber(B12,25) works ok as long as there is a
> symbol in cell B12 but returns "error" if no symbol in B12. is there a way
> to avoid this?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.: Re: =RCHGetElementNumber(B12,25) returns "error" if no symbol in "B1

Posted by: "Digger" cavesinarizona@yahoo.com cavesinarizona

Sun Aug 14, 2011 3:30 am (PDT)

THANK YOU SO MUCH!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Normal EXCEL can handle that situation:
>
> =IF(LEN(B12)=0,"--",RCHGetElementNumber(B12,25))
>
> On Sun, Aug 14, 2011 at 1:55 AM, Digger <cavesinarizona@...> wrote:
>
> > the function =RCHGetElementNumber(B12,25) works ok as long as there is a
> > symbol in cell B12 but returns "error" if no symbol in B12. is there a way
> > to avoid this?
> >
>

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