EXCEL
().
Excel :
1. .
2. .
3. .
4. :
4.1. .
4.2. .
4.3. .
5.
6. .
7.
, (. 1).
1 .
Excel . 2.
A | B | C | D | E | F | |
1 | 2 | |||||
max | ||||||
() | ||||||
A | ||||||
B | ||||||
C | ||||||
D | ||||||
. 2 |
.2 .
2 .
1 (.2).
.
1.1. B3:C3 .
1.2. 4:4 , , , 1.
1.3. B7:C10 .
1.4. F7:F10 .
1.5. E7:E10 <=.
(. 24).
2.1. D4 :
= B3 * B4 + C3 * C4 = (B3:C3;B4:C4)
(1; 2; 3;) , . () .
|
|
:
1 B3:C3.
2 B4:C4.
2.2. D7 :
= B7 * B4 + C7 * C4 = (B7:C7;B4:C4)
2.3. D7 B4:C4:
= B7 * $B$4 + C7 * $C$4 = (B7:C7;$B$4:$C$4)
2.4. D7 D8:D10.
2 Excel . 3.
A | B | C | D | E | F | |
1 | 2 | |||||
=(3:3;4:4) | max | |||||
() | ||||||
A | =(7:7;$$4:$$4) | <= | ||||
B | 0,5 | =(8:8;$$4:$$4) | <= | |||
C | =(9:9;$$4:$$4) | <= | ||||
D | =(10:10;$$4:$$4) | <= | ||||
. 3 |
3 . .
. .
. Excel .
4 . .
1. .
.
: D4.
:
: .
.
.
: $B$4:$C$4.