2012 Archives by date, by thread · List index

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

```Am 30.06.2012 14:09, Ken Springer wrote:
```
```After reading your other new replies, I'm wondering if the way I wrote
my posts led you to some wrong conclusions.  Possibly, it came out
sounding more complicated than the problem really was, as I did get it
solved.

It wasn't the logic or the functions that needed to be used that was my
problem, that was easy.   :-)

It was the actual formatting of the functions in the cell that was the
problem.  Do I need parens here?  Should there be a space and capitals?
How are the functions I need supposed to be entered, as a group, into
the cell?  Should these two functions be grouped in parens?
```
```

Each and every function call is followed by a pair of parens.
```
=NOW without parens returns the value of a cell named "NOW" (it is possible to give names to cells).
```
Function with no parameter:
=NOW() returns the current time as number
```
_Try_out_: =NOW(13) --> Err:508 13 is pointless when you want to know the time.
```
Function with exactly one parameter:
=UPPER(A1) returns the text in A1 in upper case letters.
Only functions of category "Text" return text.
_Try_out_:  =UPPER(A1,13,A2) --> Err:508
=UPPER() --> Err:510

Function with 2 parameters plus one optional parameter:
```
=MATCH(A1,\$X\$1:\$X\$99) looks up A1 in ascending scale X1:X99 returning the position number.
```=MATCH(A1,\$X\$1:\$X\$99,0) looks up exact match of A1 in X1:X99
=MATCH(A1,\$X\$1:\$X\$99,1) same as first variant
_Try_out_: =MATCH()
=MATCH(A1)
=MATCH(A1;\$X\$1:\$Z\$99) --> Err:504
=MATCH(A1,\$X\$1:\$X\$99,3,4)

Function with at least one parameter and up to 30:
```
=SUM(A1:A99) --> sum of all numbers in vertical vector A1:A99 (one parameter, up to 99 values)
```=SUM(13) --> 13 (obsolete sum of 1 value)
```
=SUM(A1:A99,B3:F3,X1:Z13,12) sum of all numbers in a vertical vector, a horizontal vector, a 2-dimensional range plus number 12 (4 parameters)
```_Try_out_: =SUM()
=SUM("123",13)
=SUM(1,2,3,4)

You may add more parens according to common rules (1+2)*13=39 vs. 1+2*13=27

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

### Context

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 Mozilla Public License (MPLv2). "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.