vert line

! or::

Links worksheets

sheet!adr

sheet the name of the worksheet to be linked

adr the address of a cell or range in sheet

These operators create a link to another worksheet, specified by the filename of the worksheet, and the address of a cell or range in that worksheet. A worksheet link will return the value of the cell or range. Linked worksheets need to be in the same directory.

="Exports"::B52 -> Returns the contents of cell B52 in the worksheet named Exports.

=U2!I9 -> Returns the contents of cell I9 in the worksheet whose name is in cell U2 of this worksheet

=sum("Exports"!A1:B20) -> Returns the sum of the numbers in the range A1:B20 in the worksheet named Exports

=sum(U2::prices) -> Returns the sum of the numbers in the range labeled prices in the worksheet whose name is in cell U2 of this worksheet.

&

string concatenation

string1&string2

This operator concatenates the two strings on either side of it, forming one string.

="this"&"that" -> thisthat

A B

1 this that

=A1&B1 -> thisthat

= or ==

equal

exp1=exp2

Expressions containing this operator are true if the value of the first expression is equal to the value of the second expression.

!= or <>

not equal to

exp1!=exp2

This operator tests to see if one expression is not equal to another.

if(1!=0, "OK") -> OK

<

less than

num1<num2

Expressions containing this operator are true if the value of the first number is smaller than the value of the second number.

>

greater than

num1>num2

Expressions containing this operator are true if the value of the first number is larger than the value of the second number.

<= or =<

less than or equal to

num1<=num2

Expressions containing this operator are true if the value of the first number is either less than or equal to the value of the second number.

>= or =>

greater than or equal to

num1>=num2

Expressions containing this operator are true if the value of the first number is either greater than or equal to the value of the second number.

+

addition operator

num1+num2

This operator returns the sum of the given numbers.

=4+5 -> 9

-

subtraction operator

num1-num2

This operator subtracts the second number from the first number.

=10-2 -> 8

*

multiplication operator

num1*num2

This operators returns the product of the given numbers.

=3*5 -> 15

/

division operator

num1/num2

This operator divides the first number by the second number.

=20/5 -> 4

^

exponentiation operator

num1^num2

This operator raises the first number to the power given by the second number. In other words it multiplies the first number by itself a number of times specified by the second number.

#AND#, &&, <AND>, or AND

logical AND

exp1#AND#exp2

This operator serves as a logical AND. When used to link two expressions, the entire expression is true only if both separate expressions are true.

#OR#, <OR>, OR, or ||

logical OR

exp1#OR#exp2

This operator serves as a logical OR. When used to link two expressions, the entire expression is true if either of the two expressions is true.

<XOR>, XOR, or ^^

exclusive OR

exp1<XOR>exp2

Expressions containing this operator are true if either, but not both, or the given expressions are true.

 

Also go to:

Index help

Contents help