Share in Facebook


30 May 2017

Operators in Excel Uses of Operators in MS Excel

Today I would like to highlight some points about OPERATOR.
Operators specify the type of calculation that you want to perform on the elements of a formula, like addition, subtraction, multiplication or division. There is a default order in which calculations occur, but you can change this order by using parentheses.

Arithmetic operators


To perform basic mathematical operations such as addition, subtraction, or multiplication; combine numbers; and produce numeric results, use the following arithmetic operators.


Comparison operators

You can compare two values with the following operators. When two values are compared by using these operators, the result is a logical value either TRUE or FALSE.



Operator precedence

If you combine several operators in a single formula, Excel performs the operations in the order shown in the following table. If a formula contains operators with the same precedence — for example, if a formula contains both a multiplication and division operator — Excel evaluates the operators from left to right.
In a simpler language “How a formula decides which operator’s job to be processed first”.



No comments: