Operators are the type of calculation in excel which you want to perform on the elements of a formula, such as addition, subtraction, multiplication or division.
IN TITLE: Operators in Microsoft Excel
Arithmetic Operator
IN TITLE: Operators in Microsoft Excel
Arithmetic Operator
Arithmetic operator
|
Meaning
|
Example
|
+ (plus sign)
|
Addition
|
3+3
|
– (minus sign)
|
Subtraction
Negation |
3–1
–1 |
* (asterisk)
|
Multiplication
|
3*3
|
/ (forward slash)
|
Division
|
3/3
|
% (percent sign)
|
Percent
|
20%
|
^ (caret)
|
Exponentiation
|
3^2
|
Comparison operators
Comparison operator
|
Meaning
|
Example
|
= (equal sign)
|
Equal to
|
A1=B1
|
> (greater than sign)
|
Greater than
|
A1>B1
|
< (less than sign)
|
Less than
|
A1<B1
|
>= (greater than or equal to sign)
|
Greater than or equal to
|
A1>=B1
|
<= (less than or equal to sign)
|
Less than or equal to
|
A1<=B1
|
<> (not equal to sign)
|
Not equal to
|
A1<>B1
|
Text concatenation operator
Text operator
|
Meaning
|
Example
|
& (ampersand)
|
Connects, or concatenates, two values to produce one continuous text value
|
("North"&"wind")
|
Reference operators
Reference operator
|
Meaning
|
Example
|
: (colon)
|
Range operator, which produces one reference to all the cells between two references, including the two references
|
B5:B15
|
, (comma)
|
Union operator, which combines multiple references into one reference
|
SUM(B5:B15,D5:D15)
|
(space)
|
Intersection operator, which produces on reference to cells common to the two references
|
Post a Comment