Re: [libreoffice-users] Error in Calc logical functions

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
>
>    


--
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