Re: Ignoring charachter data with Product function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: N Harkawat (nh_at_nh.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 09:04:49 -0500

Hope this helps
=PRODUCT(IF(ISNUMBER(A2:A8),(1+A2:A8)))
array entered(ctrl+shift+enter) instead of just enter

"Stan Altshuller" <ctaca@hotmail.com> wrote in message
news:OI5rZ4S3EHA.3380@TK2MSFTNGP09.phx.gbl...
> Hi all
>
> in short:
> I have row A of data that has numbers between -1 and 1 and some
> characters.
> I need to find the value of Product(1+A:A). Using the function N to
> convert
> chars to nums has not done the trick.
>
> more detail:
>
> I get a data dump of return numbers in percent from a third party software
> that I must link to. Upon linking to a different spread sheet I use
>
> =IF(DataIn!A1=0,"",DataIn!A1)
>
> and drag this forumla to get rid of zeros in my linked data.
>
> then I must find the total returns for all colums.
> If I use Product(1+A1:A10) I get #Value since there are chars in the data
> (even though Its only "" it does not work.) I must use Product(1+randge)
> not
> simply product(range) since this is return data and I must add a 1 first
> to
> find the correct return.
> Any ideas?
> Thanks!
> Stan
>
>

Relevant Pages

  • Re: fgets not doing as I expect.
    ... I wanted to limit how many chars I read in, ... number of characters specified by n from the stream pointed ... immediately after the last character read into the array. ... null pointer is returned. ...
    (comp.lang.c)
  • Re: Ignoring charachter data with Product function
    ... >> characters. ... >> chars to nums has not done the trick. ... >> then I must find the total returns for all colums. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: writing 5 bits at the time to a file
    ... So are you saying create an array of 5 chars like ... then read in 8 characters at the time, shift manipulate them into the glob ... For example if input file contains string ...
    (comp.lang.c)
  • RE: regex - no field seperator
    ... >>> I have the following data that I'm trying to parse into an array. ... >> You say it is a total of 13 characters, but in this case you have 10 ... > reached its maximum length of 6 chars. ...
    (perl.beginners)
  • Re: C Code is not generating the required results.
    ... x is an array of 4 arrays of 30 pointers to chars each. ... string in question will be at most 30-1 characters long. ...
    (comp.lang.c.moderated)