# 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.