11 : . : (.. 1) , . (.. 0), .
, 12. ( ) (SUMPRODUCT), :
=(1;2;),
=SUMPRODUCT(1;2;).
(7:10) 7:10, 7:10 D7:D10, $ $7:$$10 (.25). 12:D12.
13 . , , 12:D12 . 14 =(12:D12) (=MAX(12:D12) OpenOffice.org Calc).
, , . , ( 14) ( 12), , ("").
24
A | B | C | D | E | |
() | |||||
- 1, - 0 | |||||
? | |||||
? | |||||
? | |||||
? | |||||
( OpenOffice.org Calc IF). :
|
|
=(; 1; 2).
=IF(; 1; 2).
: . , , , 1. 2.
16
=(12=14;;0),
=IF(12=14;;0).
, , 16 . ( 0).
16
=(12=14;;0),
=IF(12=14;;0).
D16
=(D12=D14;;0),
=IF(D12=D14;;0).