Operators are the symbols which are used to perform mathematical calculation according to the data type.
For e.g. +, -, <, >, & etc are the operators.
With the help of these operators, you perform simple mathematical calculations, a mathematical calculation based on condition, basic operation on the text such as join the text but this is rarely used.
Operators in Ms-Excel specifies the type of calculation to be performed on a given set of values.
Basically, there are 4 types of operators in Excel, mentioned below:
- Arithmetic Operators.
- Logical/Comparison Operators.
- Text Concatenation Operator.
- Reference Operators.
As the word itself suggest, Arithmetic Operators are used for arithmetic operations like addition, subtraction, multiplication, division, etc. As can be guessed, this set of operators can be used for numeric calculations.
The following are the arithmetic operators available in Excel.
- + Plus (addition):-
With the help of this operator, you perform the addition calculation on ms-excel. For e.g.
In the above figure, I3 cell is the total of all subjects which is calculated by SUM function but in this case, another formula also is used "=D3+E3+F3+G3+H3". Let me explain, if you want to sum numbers in ms-excel, firstly type the equal symbol (=) just type the address (location) of cells and adds the + sign symbols between cells. For e.g. "=A1+B1"
- - Minus (subtraction):-
This operator is used to perform subtraction. For e.g. In the below figure, To calculate Net Amount (H8 Cell), you need to subtract Total-discount but using formula "=F8-G8" in ms-excel.
- * An asterisk (multiplication):-
This Asterisk symbol is used to perform multiplication on ms-excel. In the above figure to calculate Total, you need to multiply Item Price with Quantity No., to do that you need to multiply D8 cell with E8 cell. For e.g. typing the formula "=D8*E8" in the Total (F8) Cell to find out the total amount.
- / Slash (division):-
The division operator is used to divide the numbers in ms-excel. In the below figure, to calculate the Percentage, here we divide the total marks of all subjects with the number of subjects. We divide the Total (I4) cell with 5 by typing the formula "=I4/5" in the J4 cell.
- % Percent:-
In the ms-excel, we calculate the percentage by multiplying the number with the % symbol in the formula. For e.g., in the below figure, to calculate the VAT of an item, here we multiply the Amount with 13%.
- ^ Caret (exponentiation):
In the ms-excel, to calculate the value of the square number or number of power, we need to use Caret Symbol between the numbers. For e.g. to calculate the square of the 5 number, we need to write the "=5^2" formula in ms-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). Here I show you the figure in which these operators are to be defined.
- = Equal to
- < Less than
- > Greater than
- >= Greater than or Equal to
- <= Less than or Equal to
Working with text in Excel, you have the ability to concatenate multiple parts of the text in a single unit. For this purpose, you can use 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.
Excel has one operator which helps to join in two or more text strings and produces a single text line. We can use the ampersand (&) operator to join two or more strings and get a single text line.
Operators references in Excel
There are three operator's references for 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)
The 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. Below are the example of the above operators.
This is all about Operators in Ms-excel, if you have any problems to use these above operators in ms-excel, feel free to comments here, I'll answer you as soon as possible.
No comments:
Post a Comment