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