On 12-07-2011 19:05, Alejo C.S. wrote: > 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. >
no, it does not from the line which has 11 in the first column the answer shows 'TRUE' Your usage of the function IF() is wrong, there should be three parameters: IF (test, then_value, otherwise_value) try adding in column c: A1-10 if the result is <= 0 then => FALSE if the result is >=1 then => TRUE -- Luuk -- 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