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. <alej....@gmail.com> To: users@global.libreoffice.org 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. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@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