(=)
.
:
varname = expression
varname - VBA
expression - VBA
VBA , , .
X = 5 + 7; Y = X + 5; Z = X - Y; A = B; I = I + 1
, , . , .
, = +5, 7, 12 (7+5).
:
( ) ( Variant);
(, Double - Long), VBA , ;
String Variant, , VBA .
(+)
. , VBA . Date.
, . , :
Single Long Double;
Date Date;
Integer, VBA Long;
Long, Single, Date, VBA Double;
Null, Null.
: Byte, Integer, Long, Single, Double, Currency.
, VBA . "" .
(-)
: ; ( , , ). , -1.
|
|
() , VBA . .
VBA , , . , :
Date, Double.
(*)
- . , VBA .
VBA , , . Variant, Date, .
(/)
.
- .
, VBA .
Null, Null.
Double, :
Integer Single - Single;
Single.
(\)
, .
, VBA .
VBA Integer Long ( ).
VBA ( !) . , 22\5 24\5 = 4.
Null, Null.
(Mod)
. .
22 Mod 5 = 2
24 Mod 5 = 4
25 Mod 5 = 0
.
(^)
.
5 ^ 3 =125
, VBA .
, .
Double.
Null, Null.
|
|
:
+ | A + B | : . |
- | A - B | : . |
* | A * B | : . |
/ | A / B | : . |
\ | A \ B | : , . - . |
Mod | A Mod B | : , . |
^ | A ^ B | : . |
VBA
AND | A AND B | : True, - True. - False |
OR | A OR B | : True, - True. - False |
NOT | NOT A | : False, - True. - False |
XOR | A XOR B | : True True, - True. - False |
EQV | A EQV B | : , - True. - False |
, Boolean, , Boolean.
Boolean ( Null, Null).
AND
:
_1 AND _2
AND .
True, True, - False.
_1 | _2 | |
True | True | True |
True | False | False |
False | True | False |
False | False | False |
AND :
(5<7) AND (4>3) AND (5=6) False
AND True , True. False. , . VBA , .
OR
:
_1 OR _2
OR .
True, True, - False.
_1 | _2 | |
True | True | True |
True | False | True |
False | True | True |
False | False | False |
OR :
(5<7) OR (4>3) OR (5=6) True
OR True , True. False.
AND OR :
((5<7) AND (4>3)) OR (5=6) True
NOT
:
NOT
NOT .
NOT .
True | False |
False | True |
AND OR NOT :
((5<7) AND (4>3)) OR NOT (5=6) True
XOR
:
_1 XOR _2
XOR .
True, , - False.
_1 | _2 | |
True | True | False |
True | False | True |
False | True | True |
False | False | False |
|
|
((5<7) AND (4>3)) OR NOT (5=6) XOR (5=5) False
EQV
:
_1 EQV _2
EQV - .
True, , - False.
_1 | _2 | |
True | True | True |
True | False | False |
False | True | False |
False | False | True |
((5<7) AND (4>3)) OR NOT (5=6) EQV (5=5) True.
= | A = B | : , - True. - False |
< | A < B | : , - True. - False |
<= | A <= B | : , - True. - False |
> | A > B | : , - True. - False |
>= | A >= B | : , - True. - False |
<> | A <> B | : , - True. - False |
- .
Boolean: True, False.
, VBA .
, VBA .
Variant, VBA Variant - .