|
![]() |
![]() |
! 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. |
||
|
||