In This Topic
Represents formula operators.
Members
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. Syntax: @code:expression1 + expression2 or @code:+expression2 Parts: @code:expression1: Optional. Any numeric or string expression. @code:expression2: Required. Any numeric or string expression. 
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. Syntax: @code:expression1 & expression2 Parts: @code:expression1: Required. Any expression with a data type that widens to String. @code:expression2: Required. Any expression with a data type that widens to String. 
Division  Represents the / operator.
Divides two numbers and returns a floatingpoint result, including any remainder. The @code:QUOTIENT function returns the integer quotient, which drops theremainder. Syntax: @code:expression1 / expression2 Parts: @code:expression1: Required. Any numeric or string expression. @code:expression2: Required. Any numeric or string expression. 
Equality  Represents the = operator.
The equality operator compares two expressions to determine whether or not they are equal. Syntax: @code:expression1 = expression2 Parts: @code:expression1: Required. Any expression. @code:expression2: Required. Any expression. 
Exponent  Represents the ^ operator.
Raises a number to the power of another number, always as a @code:doublevalue. Syntax: @code:number ^ exponent Parts: @code:number: Required. Any numeric or string expression. @code:exponent: Required. Any numeric or string expression. 
GreaterThan  Represents the > operator.
The greater than operator compares two expressions to determine whether the left side is greater than the right side. Syntax: @code:expression1 > expression2 Parts: @code:expression1: Required. Any expression. @code:expression2: Required. Any expression. 
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. Syntax: @code:expression1 >= expression2 Parts: @code:expression1: Required. Any expression. @code:expression2: Required. Any expression. 
Inequality  Represents the <> operator.
The inequality operator compares two expressions to determine whether they are not equal. Syntax: @code:expression1 <> expression2 Parts: @code:expression1: Required. Any expression. @code:expression2: Required. Any expression. 
Intersection  Represents the (space) operator.
The intersection operator gives reference to those cells which are common in two range arguments. Syntax: @code:range1 range2 Parts: @code:range1: Required. Must be a range expression. @code:range2: Required. Must be a range expression. 
LessThan  Represents the < operator.
The less than operator compares two expressions to determine whether the left side is less than the right side. Syntax: @code:expression1 < expression2 Parts: @code:expression1: Required. Any expression. @code:expression2: Required. Any expression. 
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. Syntax: @code:expression1 <= expression2 Parts: @code:expression1: Required. Any expression. @code:expression2: Required. Any expression. 
Multiply  Represents the * operator.
Multiplies two numbers. Syntax: @code:expression1 * expression2 Parts: @code:expression1: Required. Any numeric or string expression. @code:expression2: Required. Any numeric or string expression. 
Percentage  Represents the % operator.
Divides a number by 100. Syntax: @code:expression1% Parts: @code:expression1: Required. Any numeric or string expression.

Range  Represents the : operator.
The range operator gives a range of cells within start point and end point reference cells. Syntax: @code:range1:range2 Parts: @code:range1: Required. Must be a range expression. @code:range2: Required. Must be a range expression. 
Single  Represents the £À operator. Aggregates a range of cells spilled by Dynamic Array functions into a single cell. Syntax: @code:@expression Parts: @code:expression: Required. Any range or function call expression.

Spill  Represents the # operator.
Refers to a range of cells spilled from the specific cell. Syntax: @code:expression# Parts: @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. Syntax: @code:expression1  expression2 or @code:expression2 Parts: @code:expression1: Optional. Any numeric or string expression. @code:expression2: Required. Any numeric or string expression. 
Union  Represents the @code:, operator.
The union operator combines two or more than two references into a single reference. Syntax: @code:range1,range2 Parts: @code:range1: Required. Must be a range expression. @code:range2: Required. Must be a range expression. 
Inheritance Hierarchy
java.lang.Object
java.lang.Enum
com.grapecity.documents.excel.expressions.OperatorKind
See Also