Stop searching. Start learning and developing your excel skills.
Macro
VBA
Formula
Function
Shortcut
Tricks

» » Operators

Operators

August 13, 2017 |
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

No comments:

Post a Comment