Using Math Operators

Math operators represent special mathematical features that you can use in formulas. You can use arithmetic operators and logical operators.

Arithmetic Operators

Arithmetic operators perform the most basic mathematical operations on numbers.

  • A1+A2 (Add) – Adds values together. For example, 1+2 = 3

  • A1-A2 (Subtract) – Subtracts the value on the right from the value on the left. For example, 3-2 = 1

  • -A1 (Negate) – Makes a value negative.

  • A1*A2 (Multiply) - Multiplies values. For example, 2*3 = 6

  • A1/A2 (Divide) - Divides the value on the left by the value on the right. For example, 6/3 = 2

  • A1^A2 (Raise to the Power) – Multiples value on the left by itself the number of times of value on the right. For example, 2^3 = 2*2*2 = 8

  • A1:A2 (Sum a Range) – Adds the values of all the cells in the specified range.

  • # (Wild Card) - Replaces either the row or column specified within a cell specification. [#1 : #3]- Sums cells in rows 1 through 3, [A# : D#]- Sums cells in columns A through D.

Logical Operators

Logical operators compare two or more numeric or text values and return a result of 1 if the statement is true or 0 if the statement is false.

  • A1=A2 (Equal to)

  • A1>A2 (Greater than)

  • A1<A2 (Less than)

  • A1<>A2 (Not equal to)

  • A1&A2 (And) - When placed between two or more logical statements, returns a 1 (true) if all of the statements are true and a 0 (false) if any of the statements are false.

  • A1\A2 (Or) - When placed between two or more logical statements, a 1 (true) is returned if at least one of the statements is true. A 0 (false) is returned if all of the statements are false.