Transcription of EXCEL²Ä2½g²Ä4³¹ - 碁峰資訊
1 4 . ch . 4-1 .. (.. ).. 1.. 2-4-1-1 . 2 .. 2-4-1-2 . 4-2. 4 .. 3.. 2-4-1-3 . 4-2 .. = - +.. 1 . 4-3. A . B . C . D . + + . 2 ( ) . A . B . C . D +. + . E - .. 3 . A . B . C . 4 . A . B . 4-4. 4 .. 2-4-2-1 .. 1 . (B5:M5 ). ( B5:M5).. B5.. C5 . =B22. D5 =C22. E5 =D22. F5 =E22. G5 =F22. H5 =G22. 4-5.. I5 =H22. J5 =I22. K5 =J22. L5 =K22. M5 =L22. 2 . (B8:M8 ). +.. + . SUM().. B8 =SUM(B5:B7). C8 =SUM(C5:C7). D8 =SUM(D5:D8). E8 =SUM(E5:E7). F8 =SUM(F5:F7). G8 =SUM(G5:G7). H8 =SUM(H5:H7). I8 =SUM(I5:I7). J8 =SUM(J5:J7). K8 =SUM(K5:K7). L8 =SUM(L5:L7). M8 =SUM(M5:M8). 4-6. 4 .. 3 (B22:M22 ).. = - +.. B22 =B8 B14 +B20. C22 =C8 C14 +C20. D22 =D8 D14 +D20. E22 =E8 E14 +E20.
2 F22 =F8 F14 +F20. G22 =G8 G14 +G20. H22 =H8 H14 +H20. I22 =I8 I14 +I20. J22 =J8 J14 +J20. K22 =K8 K14 +K20. L22 =L8 L14 +L20. M22 =M8 M14 +M20. 4 . (B23:M23 ).. = IF( = 0, . IF( <> 0, 1, 0), ( . - ) / ). 4-7.. B23 =0. C23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). D23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). E23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). F23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). G23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). H23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). I23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). J23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). K23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). L23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22).
3 M23 =IF(B22 = 0,IF(C22<>0,1,0), (C22-B22)/B22). 2-4-2-2 . 4-3 .. (N22 ). 4-8. 4 .. 1 N22.. 2-4-3-1 . 2 . 8.. 2-4-3-2. 2-4-3-2 . 8 . 3 .. 1,000,000. 2-4-3-3 .. 1,000,000.. 4-9. 4 . 2-4-3-4 . 5 . 2-4-3-5 . 4-10. 4 .. 6 N22. 1,000,000.. 2-4-3-6 N22 1,000,000 .. 4-4 .. 1 .. 2 .. 4-11.
