Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education


Arithmetic, comparing, text and reference operators in Excel

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:
  1. Arithmetic operators
  2. Comparison operators
  3. Text operators
  4. 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.

arithmetic or mathematical 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
Comparison operators 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).

Text concatenation operator in Excel

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 ,).

Operators references 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 sequence of operations in Excel