AND : TRUE, TRUE.
NOT : .
OR : TRUE, TRUE.
, ,
(AND),
(OR),
(NOT)
- . . 30 :
=(_1;_2...)
=(_1;_2...)
:
=(_)
, , , , .
. Excel "", 4 ( 2), 3 ( 3). :
=((2>4;3<3);"";" ")
, , , . , , , ( 4 3). , , , , .
. , , , .
, , . . , :
=(1=100;"";((1>=80;1<100);"";((1>=60;1<80);"";"")))
1 , : " 1 100, "". , 1 80 100, "". , 1 60 80, "". , , "". 7 .
|
|
AND
: Microsoft Office Excel 2007
AND Microsoft Office Excel.
, ; Ͳ, Ͳ.
AND , . , IF , , , Ͳ. AND _ IF, .
AND(1; [2];...)
AND :
1 ' . , Ͳ.
2;... ' . 255, Ͳ.
, Ͳ, ,
.
, , , .
, AND #VALUE!.
NOT
: Microsoft Office Excel 2007
. NOT , , .
NOT()
- , Ͳ.
Ͳ, NOT ; , NOT Ͳ.
( -).
( = 2 AND NOT (> 3) AND <4) OR ( = 3 AND > 5 AND NOT ( <7)) OR (> 4 AND > 6 AND <8)
(³> 80 AND NOT ( <100)) OR (NOT (³> 80) AND <100)
.
NOT ((³> 80 AND NOT ( <100)) OR (NOT (³> 80) AND <100))
(³> 80 OR NOT ( <100)) AND (NOT (³> 80) AND <100)
- .
3. AND- (1 AND 2 AND... AND ), 1, 2,..., - , . - ' AND-.