# Operators in a Formula

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



The following table lists the available operators. For each operator, an example is given of the syntax of using a literal value as well as a cell reference. The type of value returned is given for each type of operator.

| Operator | Description | Literal & Literal | Cell Ref & Literal | Type Returned |
| -------- | ----------- | ----------------- | ------------------ | ------------- |
| + | Add | 5 + 3 | A1 + 3 | double |
| – | Subtract | 5 – 3 | A1 – 3 | double |
| \* | Multiply | 5 \* 3 | A1 \* 3 | double |
| / | Divide | 5 / 3 | A1 / 3 | double |
| ^ | Exponent | 5 ^ 3 | A1 ^ 3 | double |
| & | Concatenate | "F" & "p" | A1 & "p" | string |
| = | Equal |  | A1 <> 3 | boolean |
| < > | Not Equal |  | A1 = 3 | boolean |
| < | Less Than |  | A1 < 3 | boolean |
| > | Greater Than |  | A1 > 3 | boolean |
| <= | Less Than Or Equal |  | A1 <= 3 | boolean |
| \>= | Greater Than Or Equal |  | A1 >= 3 | boolean |
| \- \(Unary Operator\) | Negate | -(5/3) | -(A1/3) | double |
| + (Unary Operator) | Plus | +(5/3) | +(A1/3) | double |
| % | Percent | (5/3)% | (A1/3)% | double |

Operators specify the type of calculation that you want to perform on the elements of a formula. Most of the operators return double-precision floating point values for mathematical operations and boolean (or logical) values for comparison operators.
In Spread, all arithmetic operators (including the unary +) check their arguments and return a #VALUE error if any of the arguments are strings that can not be converted to a number. This is mathematically correct behavior and can not be overridden. For example, the three formulas +B5 and 0+B5 and --B5 should all produce the same result and, in Spread, they do.
Because more than one operator may be used in a formula, so be sure you understand the [Order of Precedence](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-operators/formulas-orderprecedence).
The mathematical operators and unary operators may also be used with date-time and time-span values, as summarized in [Using Operators with Dates and Times](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-operators/formulas-operatedatetime).