Re: [libreoffice-users] Error in Calc logical functions

Michael

Excellent, I did not know ISNUMBER existed, I never needed it before,  
but for my usage I would remove the word "Non-numeric" and just leave "" 
so the cell would remain blank.

I can see that in LO or any other spreadsheet that treats Letters as 
Numbers, this would be a necessary function.

I have learned something today - thanks

John B


--------------------------------------------------------------------------------------------------------------------------

On 13/07/2011 13:24, Michael D. Setzer II wrote:
> How about this formula.
>
> =IF(ISNUMBER(A1),IF(A1>10,"True","False"),"Non-numeric")
>
>                                                                     1
> False
>
>                                                                     2
> False
>
>                                                                     3
> False
>
>                                                                     4
> False
>
>                                                                     5
> False
>
>                                                                     6
> False
>
>                                                                     7
> False
>
>                                                                     8
> False
>
>                                                                     9
> False
>
>                                                                    10
> False
>
>                                                                    11
> True
>
> A
> Non-numeric
>
>                                                                    13
> True
>
>                                                                    14
> True
>
>                                                                    15
> True
>
>                                                                    16
> True
>
>                                                                    17
> True
>
>                                                                    18
> True
>
>                                                                    19
> True
>
>                                                                    20
> True
>
>                                                                    21
> True
>
>
>
>
> On 12 Jul 2011 at 20:14, Regina Henschel wrote:
>
> Date sent:              Tue, 12 Jul 2011 20:14:27 +0200
> From:                   Regina Henschel<rb.henschel@t-online.de>
> To:                     users@global.libreoffice.org
> Subject:                Re: [libreoffice-users] Error in Calc logical
> functions
> Send reply to:          users@global.libreoffice.org
>
>    
> > Alejo C.S. schrieb:
> >      
> > > Hi all, this is a little example to show what is going on.
> > > In A column I have a numeric list from 1 to 21, in the middle I have a
> > > letter, lets put A.
> > > If a run this function in the next column =IF(A1>10), this function
> > > evaluate the letter A like TRUE, why?
> > >
> > >
> > > 1    FALSE
> > > 2    FALSE
> > > 3    FALSE
> > > 4    FALSE
> > > 5    FALSE
> > > 6    FALSE
> > > 7    FALSE
> > > 8    FALSE
> > > 9    FALSE
> > > 10  FALSE
> > > 11  TRUE
> > > A   TRUE
> > > 13  TRUE
> > > 14  TRUE
> > > 15  TRUE
> > > 16  TRUE
> > > 17  TRUE
> > > 18  TRUE
> > > 19  TRUE
> > > 20  TRUE
> > > 21 TRUE
> > >
> > >        
> > The ODF1.2 spec says ("functions" are here the comparison operators),
> > "These functions return one of True, False, or an Error if Left and
> > Right have different types, but it is implementation-defined which of
> > these results will be returned when the types differ."
> >
> > And OpenOffice.org and LibreOffice have the simple rule "number is less
> > than string". Excel and Gnumeric have these results too.
> >
> > Kind regards
> > Regina
> >
> >
> >
> > --
> > Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
> > In case of problems unsubscribing, write to postmaster@documentfoundation.org
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be deleted
> >
> >      
>
> +----------------------------------------------------------+
>    Michael D. Setzer II -  Computer Science Instructor
>    Guam Community College  Computer Center
>    mailto:mikes@kuentos.guam.net
>    mailto:msetzerii@gmail.com
>    http://www.guam.net/home/mikes
>    Guam - Where America's Day Begins
>    G4L Disk Imaging Project maintainer
>    http://sourceforge.net/projects/g4l/
> +----------------------------------------------------------+
>
> http://setiathome.berkeley.edu (Original)
> Number of Seti Units Returned:  19,471
> Processing time:  32 years, 290 days, 12 hours, 58 minutes
> (Total Hours: 287,489)
>
> BOINC@HOME CREDITS
> SETI        10992790.927474   |   EINSTEIN     6170633.720851
> ROSETTA      3366299.645114   |   ABC          6849302.005189
>
>
>    
>
>
>
> Internal Virus Database is out of date.
> Checked by AVG - www.avg.com
> Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00
>
>    


--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted