[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

# [libreoffice-users] Re: Using and Formatting Logical Functions in Calc

Hi,

Like any other programming language Calc can nest functions as far as the data types of the incoming parameters match the data types of the nested function results. The details are mostly the same as with any other spreadsheet program of the past 30 years with the only exception that there is no boolean data type. TRUE equals 1, FALSE equals 0 without any conversion.

A Calc cell can have a number, text, blank and error. All constants are number or text, a formula may return number, text or error.

=FUNCTION(number ; text ; range ; vector )

*should* be nested like this:

=FUNCTION( function_number(x) ; function_text(x) ; function_range(x) ; function_vector(x) )

[a vector is a range made of a single row or column. Sometimes this shape is required]

The function wizard can be of great help when composing nested functions.

Personally, I avoid deeply nested function calls. They are much harder to maintain and debug.

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category
Apart from the functions of category "Text" all spreadsheet functions return numbers.
Functions of category "Spreadsheet" return references to other cells.

Am 29.06.2012 04:04, Ken Springer wrote:

I rarely use spreadsheets, as doing mathematical calculations are rare
for me. Many use spreadsheets for databases, but I would use a
database. And probably not LO Base, as there was something written
about Base in this list I couldn't believe was true, but sadly, I'm not
sure what that was. LOL, CRS!

Base is not a database. Please feel free to use your preferred connectable database and connect it with a Base document in order to use it in the context of this office suite. I do so successfully since many years (OOo 1.1) within the limits of this very simple tool set. A decent database is not exclusively bound to one particular front-end.

Hope that helps,
A.S.

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

 [libreoffice-users] Re: Using and Formatting Logical Functions in Calc Ken Springer
 [libreoffice-users] Using and Formatting Logical Functions in Calc Ken Springer Re: [libreoffice-users] Using and Formatting Logical Functions in Calc Dan [libreoffice-users] Re: Using and Formatting Logical Functions in Calc Ken Springer Re: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc Dan [libreoffice-users] Re: Using and Formatting Logical Functions in Calc Ken Springer Re: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc Dan [libreoffice-users] Re: Using and Formatting Logical Functions in Calc Ken Springer
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the GNU Lesser General Public License (LGPLv3). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.