Excel: Arithmetic Operatorss

Arithmetic Operators

A group of symbols, used by Excel, to perform basic mathematical operations such as addition, subtraction, or multiplication. Produces numeric results.

: (colon)

A range operator that helps you shorten your formula elements. For example, instead of entering B1+B2+B3+B4+B5+B6+B7, just enter B1:B7. The colon allows you to identify the 'range' of cells.

Reference Operator

Combines ranges of cells for calculations with the following operators.

Order of operation

Excel calculates the formula from left to right according to a specific order for each operator in the formula.

Calculation Operator

Separates the elements that follow the equal sign which are to be calculated.

Equal sign

The symbol that begins ALL excel formulas.

* (asterisk)

The symbol used for multiplication. For example, 5*5.

% (percent sign)

The symbol used for percentages. For example, 30%.

+ (plus sign)

The symbol used for represents addition. For example, 2+2.

- (minus sign)

The symbol used for subtraction. For example, 5-2.

/ (forward slash)

The symbol used to represent division. For example, 9/3.