Tom
That was the very 1st thing I thought, so I ran charmap on Arial and
chose an accii code less than a number such as # and it still comes up TRUE.
It should either come up as False or Error
A bug I think
regards
John B
-------------------------------------------------------------------------------------------------------------
On 12/07/2011 18:20, Tom Davies wrote:
Hi :)
In ascii code the alphabetic characters are 'higher' than the numbers. So A is
calculated as being higher than any number. Remember that the machine doesn't
really understand letter or numbers as we read them. They are all just binary
digits. the binary digit that represents the character A is 'higher' than one
representing a number.
Regards from
Tom :)
________________________________
From: Alejo C.S.<[email protected]>
To: [email protected]
Sent: Tue, 12 July, 2011 18:05:29
Subject: [libreoffice-users] Error in Calc logical functions
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
Thanks a lot in advance
C.
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 [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
