Member | Description |
---|---|

Addition | Represents the + operator.
The + operator has the primary purpose of adding two numbers. This operator is defined only for @code:double operands, and it alwaysnarrows its operands to @code:double. |

Concatenate | Represents the & operator.
Concatenation operators join multiple strings into a single string. The & operator is defined only for @code:string operands, and it always widensits operands to @code:string. |

Division | Represents the / operator.
Divides two numbers and returns a floating-point result, including any remainder. The @code:QUOTIENT function returns the integer quotient, which drops theremainder. |

Equality | Represents the = operator.
The equality operator compares two expressions to determine whether or not they are equal. |

Exponent | Represents the ^ operator.
Raises a number to the power of another number, always as a @code:doublevalue. |

GreaterThan | Represents the > operator.
The greater than operator compares two expressions to determine whether the left side is greater than the right side. |

GreaterThanOrEqual | Represents the >= operator.
The greater than operator compares two expressions to determine whether the left side is greater than or equal to the right side. |

Inequality | Represents the <> operator.
The inequality operator compares two expressions to determine whether they are not equal. |

Intersection | Represents the (space) operator.
The intersection operator gives reference to those cells which are common in two range arguments. |

LessThan | Represents the < operator.
The less than operator compares two expressions to determine whether the left side is less than the right side. |

LessThanOrEqual | Represents the <= operator.
The less than or equal operator compares two expressions to determine whether the left side is less than or equal to the right side. |

Multiply | Represents the * operator.
Multiplies two numbers. |

Percentage | Represents the % operator.
Divides a number by 100. |

Range | Represents the : operator.
The range operator gives a range of cells within start point and end point reference cells. |

Single | Represents the £À operator.
Aggregates a range of cells spilled by Dynamic Array functions into a single cell.
@code:@expression
@code:expression: Required. Any range or function call expression. |

Spill | Represents the # operator.
Refers to a range of cells spilled from the specific cell.
@code:expression#
@code:expression: Required. Any cell reference expression. |

Subtraction | Represents the - operator.
Returns the difference between two numeric expressions or the negative value of a numeric expression. |

Union | Represents the @code:, operator.
The union operator combines two or more than two references into a single reference. |