Blue Flower

Working with Excel when you are creating a formula you need to use operators. Operators define the type of operation that you want to spend in the formula. In Excel, you can use four different types of calculation operators:

  • Arithmetic operators
  • Comparison operators
  • Text operators
  • Operators reference

Arithmetic operators in Excel

  • + Plus (addition)
  • - Minus (subtraction and negation)
  • * An asterisk (multiplication)
  • / Slash (division)
  • % Percent
  • ^ Caret (exponentiation)

The sign for the exponentiation obtained key combination on the keyboard AltGr+3. In general we write the number that we want to emphasize and press AltGr and hold then press the number '3', which is located above the letters 'W' and 'E' and release the button, then press the space bar on the keyboard.

addition, subtraction, multiplication, division, exponentiation operators in Excel 

Comparison operators in Excel

Operators comparisons are used when we need to compare two values ​​or two data. In working with these operators return us to TRUE or FALSE (true or not true).

  • = Equal to
  • < Less than
  • > Greater than
  • >= Greater than or Equal to
  • <= Less than or Equal to

Operators comparing values ​​or text in Excel

Text operators in Excel

Working with text in Excel, you have the ability concatenate multiple parts of text in a single unit. For this purpose, you can use the the & character (ampersand) that concatenate two or more values ​​from multiple cells to produce one continuous text value ("earth" & "is" & "round") and the result is (earth is round) in a single cell or (1 & 2 & 3) the result is (123).

Excel operator to concatenate the the values ​​from multiple cells into a single cell

Operators references in Excel

There are three operators references in working with Excel. These operators are helping us to combine multiple ranges of cells in calculations and formulas.

  • ':' Range (colon)
  • ';' Union (semicolon) or ',' (comma)
  • 'space' intersection (blank character, using the Space key on your keyboard)

Using these operators is easier to work with formulas.
Range operator serves us to use more cells in some range of data.
Union operator separates multiple ranges of cells and makes union data.
Intersection operator, which results in a reference to cells common to the two references.

Note: The operator for the 'Union' may be 'semicolon' or 'comma' (; or ,).

Excel range, union and intersection operators in Excel

The sequence of operations in Excel

If you combine several operators in a single formula, Excel performs operations in the order shown in the picture below this text. If a formula contains operators with the same advantages. for example: if a formula contains both a multiplication operator and the division operator, Excel evaluates the operators from right to left.

the order of performing the operations in Excel