Do you need to learn how to use Excel Arithmetic Operators? This blog post explains you to apply Arithmetic Operators in excel formulas.
Operators are symbols that are used to execute operations on data. They can execute mathematical operations like addition, subtraction, multiplication, and division, as well as logical operations like comparison and evaluation.
It is very important to the excel user to have a knowledge of the priority order of the Excel Arithmetic Operator.
There are many different kinds of operators, including arithmetic, relational, logical, bitwise, assignment, and others. Each operator performs a specific purpose and is often employed in various programming languages.
Arithmetic Operators
Assume the data are in Cell B1 and B2.
| Number 1 | 10 |
| Number 2 | 2 |
| Operators | Output | Excel Formula | Comments |
| Addition | 12 | =B1 + B2 | Addition of two or more numbers |
| Subtraction | 8 | =B1 – B2 | Subtraction of two or more numbers |
| Multiplication | 20 | =B1 * B2 | Multiply B1 and B2 number |
| Division | 5 | =B1 / B2 | Divide the number B1 by B2 |
| Power | 100 | =B1 ^ B2 | Power B2 to the B1 number |
Arithmetic Operators – Priority Order
- Parentheses ()
- Exponentiation (^)
- Multiplication (*) or Division (/)
- Addition (+) or Subtraction (-)
The execution order will be left to right for the same level of precedence.
For Eg: You have a formula =(2*5) ^ (1+1). The below steps explain to you how excel executes the formula.
- Start with the first parentheses (2*5), multiply the numbers 10
- Add the numbers 1+1 in the second parentheses
- Calculate 10 ^ 2 and return 100.
Conclusions
Excel operators are powerful and flexible features for doing computations and analysing data fast. They can help users save time and simplify data analysis, allowing them to get the most out of their data. To remain competitive, it will be important to learn and understand how to use Excel operators.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
