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 users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@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