Excel 入門 ( その 3) 23 24 (a) (b) (c) (d) 1
Excel 23 Excel Excel Enter 1 2 Tab 1 Enter 2 AHP n n F2 =B2*C2*D2*E2 25 2
4 30 4 4 30 4 1 30 30 4 1 Excel G2 =F2^(1/4)^Excel 26 1 3 Excel F2 G2 G2 3 1 4 3 4 3
27 H2 =G2/$G$6 G6 $G6 G6 F4 4 Excel A1 $A1 A$1 $A$1 4
28 24 13 4 2 = 0.343 0.379 0.179 0.099 0.122 0.078 0.609 0.191 0.114 0.197 0.595 0.094 0.203 0.144 0.464 0.189 0.479 0.079 0.172 0.269 Excel 5
29 Excel REF OK Excel G3G6 ABC MMULT OK 6
30 31 7
32 CtrlShiftOK 100 100% 8
33 34 9
35 36 10
AHP (1)(2)(3) (1)(2)(3) 23 24 33 11