Operators are widely used when you don't want to use formula or don't know the proper formula for any operation.

Calculation operator including Plus, Minus, Substation, Division, Percentage, Power, Exponential are mathematics function that you can use in the mathematic operation. Mathematical operators are calculating in a sequence of  PEDMAS(Percentage, Exponential, Division, Multiplication, Addition, Subtraction) order and you can divide in order by using parenthesis.

### Arithmetic operators

The arithmetic operator calculates basic arithmetic calculations. It a manual calculation way of the formulas like Sum, Mul, Div etc

 Arithmetic Operator Meaning Example Plus (+) Addition of two or more values =1+2+3 Minus (-) Subtraction of two or more values =9-5-3 Asterisk (*) Multiplication of two or more values =5*8*3 Forward Slash (/) Division of the one value by other value =15/3 Percentage sign (%) Find percentage of the value by hundred 20% Caret (^) Power of the value 5^3 Parenthesis () Can calculate first parenthesis =5*(9/2)

### Examples:

Calculation of the 7+(6*5^2+3)
You have to use equal to sign before the equation starts in excel

we calculate this equation step by step as per PEMDAS rule
Step 1 Excel will calculate the values or equation in parenthesis. Here in the parenthesis, the first calculation is exponent value
Step 2 It will calculate multiplication values
Step 3 The addition in the parenthesis. now parenthesis  values are completed
Step 4 addition with out of the parenthesis

### Comparison Operators

Comparison Operator Compares two values and gives the result as TRUE and FALSE
IF the comparison is valid then it shows TRUE otherwise it shows FALSE

 Comparison Operator Meaning Example Equal (=) Equal to =A1=B1 Greater Than (>) Greater than =A1>B1 Less Than (<) Less Than =A1=) Greater and Equal =A1>=B1 Less Than Equal To (<=) Less and Equal =A1<=B1 Not (<>) Not Equal To =A1<>B1

### Examples

The comparison operator is used to compare two values. It will return TRUE or FALSE in result

We have taken two values and checks conditional operator
Step 1 Equal to: Here Value 1 and Value 2 both are different so result is FALSE
Step 2 Greater: Here Once value 1 is not greater than value 2 so result is FALSE but for second option value 1 is greater than value 2 so result is TRUE
Step 3 Less : It is opposite of the greater.  Here value 1 is less than value 2 so result is TRUE and for second option Value 1 is not less than value 2 so result is FALSE

### Text Operator

Text operator is used to combine or join two or more words as a string.

 Text Operator Meaning Example Ampersand (&) Concatenates two values into one =”Nathan”&” Moska” Will return Nathan Moska
The Amparsand operator is same as the function Concatenate

### Reference Operator

Reference operators used in formulas for range selection and range modification

 Reference Operator Meaning Example Colon (:) To select range from one specific cell to another A1:A5 Comma (,) Combines Multiple references to one reference =(A1:A5,B1:B5) Space ( ) Intersect operator, Common values from the two ranges A1:B5 B3:C5

Reference operators used to modify the formula

Colon(:) The colon operator is used to select the range of the data

This is known as a range from A1:B4

Comma(,) The comma operator is used to join two or more ranges
This is the two ranges and selected using comma operator
(A1:B4,D1:E4)
If you are using operator you should use parenthesis.

Space( ) The space operator is used to intersect the cell value from the two different ranges
The sum of the intersect cells are shown
From the range A1:B4 and B3:C4 only two cells are interset(B3 and B4)

And sum of these two values are shown in the result