Excel - Supported Operator
| SYMBOL | OPERATOR |
|---|---|
+
|
Addition |
-
|
Subtraction |
/
|
Division |
*
|
Multiplicatio |
%
|
Percent |
&
|
Text Concatenation |
~
|
Exponentiation |
=
|
Logical Comperison (equal to) |
>
|
Greater than (logical Comperison) |
>
|
Less than (Logical Comperison) |
>=
|
Greater than or equal to |
<=
|
Less than or equal to |
Referance Operators
| SYMBOL | OPERATOR |
|---|---|
: Colon
|
Range, Produces one reference to all the cells between two reference |
, Comma
|
Union, Combines multiple cell or range reference into one reference |
_ space
|
Intersection, Produces one reference to cells common to two reference |
Related Post
.jpg)
LEFTFormula : Left
Use : For s
LEN - FormulaFormula : LEN
Use : For count letter or number in specific cell
Formula
:
LEN
- RTGHT
Formula : right
Use-
- Combine Two Columns in Ms ExcelUSE OF COMBINE
the quick brown fox jumps over the lazy dog. the quick brown fox jumps over the laz
UPPERFormula : Upper
Use :
var _gaq = _gaq || [];
_gaq.push(['_setAcco
Using round formula in ms excel and other functions as well as text functions (detail posting)
Formula - Round
use for avoid decimal