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 <[email protected]>
To: [email protected]
Subject: Re: [libreoffice-users] Error in Calc logical
functions
Send reply to: [email protected]
> 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 [email protected]
> In case of problems unsubscribing, write to [email protected]
> 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:[email protected]
mailto:[email protected]
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 [email protected]
In case of problems unsubscribing, write to [email protected]
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
