ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§Q¥ÎExcel ¼gSigmaªººâ¦¡

§Q¥ÎExcel ¼gSigmaªººâ¦¡


5645646.JPG

Q.Q ¤p©f³Ì¦h¥u·|=SUMPRODUCT(A2*2* ROW(INDIRECT(("a1:a"&A1))))/10

POWER ¨ç¼Æ «ç»ò¥Î³£®M¤£¶i¥h(·w

½Ð¦ì¦U¦ì¤j¤j¬O§_¥i±N ¤½¦¡¢°¸ò¤½¦¡¢±¤À§O¼gEXCELªº­pºâ¦¡,Åý§Ú°Ñ¦Ò

PS:¥¼ª¾¼Æ¬Ò¥i¥H¿é¤Jªº¡C

²Ä¤@­Ó¤½¦¡
=SUMPRODUCT(POWER(B3,ROW(INDIRECT("1:"&C3))))/A3

@@§Úªá¤F«Üªø®É¶¡¥h½s ¦ý·PıÁÙ¬O©Ç©Çªº

T.T½Ö¯à«ü¾É§Ú¤@¤U

²Ä¤G­ÓºCºC«ä¯Á¤¤

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD