Excel A D-2 B-2 D-2 B2 C-2 D-2 C2-23 -
Enter D-2 B2(1000) C2(5) 5000 D-2 (D-2) (D-2) (D-3) (D-6) - 24 -
(D-3) (D-6) D (D-2) =B2*C2 (D-3) =B3*C3 (D-4) =B4*C4 Excel - 25 -
$A$1 1000 A-1 (B-1) =$A$1 (B-1) (C-2) (B-2) (C-1) (B-1) (C-2) (B-2) (C-1) 1000 $A1 (B-1) $A$1 $A1 A $ $ (C-1) (B-2) (C-2) 1 $A2 1 A$1 (B-1) $A$1 A$1 $A1 (B-2) (C-1) (C-2) 1 B$1 1 A1 $A$1 A1 A1 A$1-26 -
A1 A$1 A$1 A1 A1 SUM (H-2) (B-2) ~ (G-2) - 27 -
(H-2) (B-2) ~ (B-6) (B-7) (B-2) ~ (H-7) - 28 -
H 8 (B-2) ~ (B-6) - 29 -
Enter SUM - 30 -
MAX Enter - 31 -
(B2:B6) OK SUM ROUND ROUND(, ) ROUND(2.15, 1) 2.15 1 (2.2) ROUND(2.149, 1) 2.149 1 (2.1) - 32 -
ROUNDUP ROUNDUP(, ) ROUNDUP(76.9,0) 76.9 1 (77) ROUNDUP(3.14159, 3) 3.14159 3 (3.142) ROUNDUP(31415.92654, -2) 31415.92654 2 10 (31500) ROUNDDOWN ROUNDDOWN(, ) ( ) ROUNDDOWN(76.9,0) 76.9 1 (76) ROUNDDOWN(3.14159, 3) 3.14159 3 (3.141) ROUNDDOWN(31415.92654, -2) 31415.92654 2 (31400) Excel Book - 33 -
Enter Excel - 34 -
1-35 -
A B B B - 36 -
A B 1 Excel A B - 37 -
Alt + Enter - 38 -