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