Ãö©óExcel ¼gSigma¬ÛÃöªº°ÝÃD
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-10-26
- ³Ì«áµn¿ý
- 2012-11-14
|
Ãö©óExcel ¼gSigma¬ÛÃöªº°ÝÃD
³oÓ°ÝÃD¥Ø«e¥d¦b¬õ®Ø³B,¦]¬°¥»¨¨S¾Ç¹LVBA,©Ò¥H±o¥Î¤@¯ë¤½¦¡¼g¥X¦¹pºâ¦¡,¦ý¬OSigma¤p§Ì¥u¼g±o¥X:¿é¤Jn,±q1¥[¨ìnªºÈ,´N¤w¸g¦³ÂI«j±j¤F
¤½¦¡¦p¤U:
=SUMPRODUCT(ROW(INDIRECT("1:"&($A$1-1))))
¦bA1¿é¤Jn¥i±o1¥[¨ìnªº¼ÆÈ
¦ý¬O³o¼Ëªº¤½¦¡·Q¤£¨ìn«ç»ò®M¥Î¨ì¬õ®Ø¸Ì±ªºpºâ¦¡...
·Q¸Õ°Ý¦U¦ì¤j¤j¬O§_¦³¿ìªk¤£¥ÎVBA¼g¥X¬õ®Ø¸Ìªºpºâ¦¡,©Ò¦³¥¼ª¾¼Æ³£¬O¥i¥H¿é¤Jªº¡C |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 1# larry6705
B1¶ñu
C1¶ñ£f
D1¶ñs
E1=¬õ®ØÈ =SUMPRODUCT(POWER(C1,ROW(INDIRECT("1:"&D1-1)))/(POWER(B1,ROW(INDIRECT("1:"&D1-1)))*FACT(ROW(INDIRECT("1:"&D1-1)))))
³o¼Ë¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-10-26
- ³Ì«áµn¿ý
- 2012-11-14
|
¦^´_ 2# stillfish00
ÅçÃÒ¤¤,·PÁ¤j¤j¼ö±¡¸Ñµª |
|
|
|
|
|
|
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-10-26
- ³Ì«áµn¿ý
- 2012-11-14
|
|
|
|
|
|
|