Operator Type
|
Operator
|
Purpose
|
A
|
B
|
Equation
|
Result
|
Arithmetic
|
+
|
Add
|
1
|
20
|
A + B
|
21
|
-
|
Subtract
|
2
|
19
|
A - B
|
-17
|
|
*
|
Multiply
|
3
|
18
|
A * B
|
54
|
|
/
|
Divide
|
4
|
17
|
A / B
|
0.23529
|
|
^
|
Exponential
|
5
|
16
|
A ^ B
|
65536
|
|
Comparison
|
=
|
Equal
|
6
|
15
|
A = B
|
FALSE
|
<>
|
Not Equal
|
7
|
14
|
A
<> B
|
TRUE
|
|
>
|
Greater Than
|
8
|
13
|
A
> B
|
FALSE
|
|
<
|
Less Than
|
9
|
12
|
A
< B
|
TRUE
|
|
>=
|
Greater Than or Equal
|
10
|
11
|
A
>= B
|
FALSE
|
|
<=
|
Less Than or Equal
|
11
|
10
|
A
<= B
|
FALSE
|
|
Logical
|
AND
|
Must Meet BOTH Condition
|
12
|
9
|
A = 0
AND B = 9
|
FALSE
|
OR
|
Must Meet ANY Condition
|
13
|
8
|
A =
13 OR B = 0
|
TRUE
|
|
NOT
|
Reverse ANY Logical
|
14
|
7
|
NOT
(A = 0 OR B = 7)
|
FALSE
|
|
Concatenate
|
+
|
Add 2 Values
|
15
|
6
|
A + B
|
21
|
+
|
Concatenates 2 Values
|
ABC
|
DEF
|
A + B
|
ABCDEF
|
|
&
|
Concatenates 2 Values
|
ABC
|
DEF
|
A
& B
|
ABCDEF
|
Stop searching. Start learning and developing your excel skills.
Operators
August 13, 2017 |
Labels:
First Step
Other Excel Tutorials:
Subscribe to:
Post Comments (Atom)
!doctype>
No comments:
Post a Comment