::Online Microsoft Office,Web ,Graphic and many more Tutorials
Operators And Formula :
A formula in a spreadsheet, such as Excel, is a mathematical equation used to caluculate a value. In Excel formulas must begin with an equal ( = ) sign.
Operators :
A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators. A value involved in an operation is called an operand. A symbol involved in an operation is called an operator. .
Arithmetic operators :
To perform basic mathematical operations such as addition, subtraction, or multiplication; combine numbers; and produce numeric results, use the following arithmetic operators.
Arithmetic operator
Meaning (Example)
+ (plus sign)
Addition (3+3)
– (minus sign)
Subtraction (3–1)
Negation (–1)
* (asterisk)
Multiplication (3*3)
/ (forward slash)
Division (3/3)
% (percent sign)
Percent (20%)
^ (caret)
Exponentiation (3^2)
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.
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 operator :
Use the ampersand (&) to join, or concatenate, one or more text strings to produce a single piece of text. NOTE : Used Double-quotes to enclose a string. As we reviewed earlier, a string can be an empty space, one character, or a group of characters.
Text operator
Meaning (Example)
& (ampersand)
Connects, or concatenates, two values to produce one continuous text value .
Reference operators : Combine ranges of cells for calculations with the following operators.
Reference operator
Meaning (Example)
: (colon)
Range operator, which produces one reference to all the cells between two references, including the two references (A2:A15)
, (comma)
Union operator, which combines multiple references into one reference (SUM(A2:A15,D5:D15))
(space)
Intersection operator, which produces on reference to cells common to the two references (B7:D7 C6:C8)
Using AutoCalculate
- Select the cell or range of cells whose sum (by default) is to be displayed.
- Sum value of the cell is shown at status bar.
- Besides the sum value, you can also view minimum, maximum, count numbers, count, or average on status bar by right clicking the status bar and then check the required function.