Den 07.11.2015 20:44, Lera skreiv:
В письме от 7 ноября 2015 18:49:22 пользователь Kolbjørn Stuestøl написал:
LibreOffice master – Helplibo_help/scalc/01.poUnit #92561344
<https://translations.documentfoundation.org/nn/libo_help/translate/scalc/01
.po#unit=92561344>
<item type="input">=COUNTIF(A1:A10;"<"&B1)</item> - when B1 contains
<item type="input">2006</item>, this returns 6
This example returns 6.
I made the example for you
https://www.dropbox.com/s/ln7608vv0hmzs69/example.ods?dl=0 . You can download
the file and verify this.
When I try this I get error 509.
What operator am I missing?
The error 509 indicates that you missed an operator. Perhaps, your
localization options do not use the semicolons in formulas.
See: Tool -> Options.. -> LibreOffice Calc -> Formula
Best regards,
Lera
Thank you.
My fault. I had written "$" instead of "&" in COUNTIF(A1:A10;"<"&B1).
I apologize for wasting your time.
Kolbjørn
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/l10n/
All messages sent to this list will be publicly archived and cannot be deleted
