Japanese version. Operators are symbols used for four arithmetic operations, cell references. Types of Operators Four major types exist. 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 – Function Formula Example. Result of the formula example. + Addition. 4+2 6 – Subtraction. 5-2 3 * Multiplication 4*3 12 / Division 8/2 4 % Percentage. 25% 25% ^ Power calculation. 3^2 9 The FILTER function uses … Continue reading Frequently used operators.(Microsoft Excel)