Formatting Formulas
Operators
Operators are a little more challenging to format than functions because they do not inherently have starting and ending parenthesis like functions. However, we can add parenthesis around the expression anyway.
Here is an example of finding the average of three values.
(
SUM(
{value1},
{value2},
{value3}
)
/
3
)
Sometimes if the operator is very short, I tuck it at the end of the closing parenthesis of a previous function.
SUM(
{value1},
{value2},
{value3}
) / 3
Logical operators
Operator
Description
Examples
>
Greater than
3 > 2
=> TRUE
<
Less than
2 < 3
=> TRUE
>=
Greater than or equal to
3 >= 3
=> TRUE
<=
Less than or equal to
2 <= 2
=> TRUE
=
Equal to
2 = 2
=> TRUE
!=
Is not equal to
3 != 2
=> TRUE
There are no rows in this table
Numeric operators
Operator
Description
Examples
+
Add together two numeric values
Size + 2
-
Subtract two numeric values
Price - 3.00
*
Multiply two numeric values
Price * Quantity
/
Divide two numeric values
Price / {Num People}
There are no rows in this table
For addition, use SUM()
For subtraction, use SUM() with -1 *
For multiplication and division, use long form with parenthesis. Put the operator on its own line
Thank Kuovonne for creating this content!
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.