Microsoft Excel 1. 2. 3. 4. VBA) A IV 256
BMI (Body Mass Index) AVERAGE,COUNTIF
BMI ( kg ) = 22 ( m) 2 BMI (Body Mass Index) BMI = ( kg ( m ) ) 2 BMI BMI 20 BMI 20 24 BMI 24 26.5 BMI 26.5
E1 kg Del Back Space Del Back Space E F
Enter E2 =22 C2 100 ^2 Enter
E2 E16 E2 E16
E F C 1 1234.0 OK BMI
A17 C17 N AVERAGE C2 C16 C2 C16 OK C F 1
A1 F17 D 1 2F
16 17F B17 E17 F17
A1 F17 1 1 A1 Center Zemi
A1 B1 F F M A1 B1 A2 F17D S 2 A
F O D 1 1 20 F C A 2 2 20 23.9 3 24 26.4 OK BMI
A21 A22 B20 B21 COUNTIF B3 B17 OK
(SUM) Excel 3 Sheet Sheet Sheet [BMI] [jinko] [jinko]
SUM C7 SUM (C4 C C4 C7 SUM(C4:C7) C4 C7 SUM(C4,C7 B1 J1
4 7 [ (C)]-[ ] [ (T)]-[ ] (N) (B3 (N)
[(T)] 7 [x/ (C)] [Y/ (V)] (N) (F) [ ] (N): OK
(O) [ ]- (W) OK (O) (F) MS P (O) (S) OK
C4/$C$8 / C4/C8 C5/C9 C6/C10 C4/$C$8
3-D [ (F)] - [(V)] [ (T)] [ C)]