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