Hi :) It might e worth posting a bug-report http://wiki.documentfoundation.org/BugReport The advice in the guide might be useful but far more useful is the link to post a bug-report. Good luck and regards from Tom :)
________________________________ From: John B <[email protected]> To: [email protected] Sent: Tue, 12 July, 2011 19:37:27 Subject: Re: [libreoffice-users] Error in Calc logical functions Got it Regina is correct, so:- =IF(A1>50,"False",IF(A1>10,"True","False")) Where 50 (or 1000) is higher than any number in your table regards John B ------------------------------------------------------------------------------------ On 12/07/2011 19:28, John B wrote: > Alejo > > The strange thing is is that if you reverse the logic such as > =IF(A1<11 and then reverse the True & False > > You get the same results table and but with A still being TRUE > > I am convinced this is a bug, which stops you writing an IF within an > IF such as =IF(A1<11,"False",IF(A1>10,"True","False")) which should > work - but it doesn't. > > regards > > John B > >-------------------------------------------------------------------------------- > > > > > > > > On 12/07/2011 18: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. >> >> >> >> >> 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 >> > > > > > 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 -- 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
