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

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


-- 
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