Frequently used operators.(Microsoft Excel)

Japanese version.

Operators are symbols used for four arithmetic operations, cell references.

Types of Operators

Four major types exist.

  • Arithmetic operators
  • String concatenation operators
  • Comparison operators
  • Reference operators

The arithmetic operators and string concatenation operators are easy for beginners to use and have a wide range of applications.

Comparison operators also have a wide range of uses, but require some getting used to.

Reference operators are rarely used consciously, but they can be useful if you remember their existence.

Arithmetic operators

-FunctionFormula Example.Result of the formula example.
+Addition.4+26
Subtraction.5-23
*Multiplication4*312
/Division8/24
%Percentage.25%25%
^Power calculation.3^29

The FILTER function uses + as a logical OR and * as a logical product.

String concatenation operators

-Formula Example.Result of the formula example.
&"A"&"B"&C""ABC"

Comparison operators

The result of the formula will be TRUE or FALSE.
These are rarely displayed as is.
They are mostly used in IF and SUMIF functions.

-FunctionFormula Example.
=The left and right sides are equal.A1=B1
>Left side is greater than right side.A1>B1
<Left side is less than right side.A1<B1
>=Left side is greater than or equal to right sideA1>=B1
<=Left side is less than or equal to right sideA1<=B1
<>The left and right sides are not equal.A1<>B1

Reference operators

These are operators that are rarely specified consciously.
They are often specified automatically by mouse operation.

-FunctionFormula Example.
:Multiple adjacent cells.A5:A15
,Multiple non-adjacent cells.A5:A15,C5:E15
 Whitespace characters. Multiple overlapping ranges.B7:D7 C6:C8

---