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

[µo°Ý] ¸÷¨D¤½¦¡¤Ï±À

[µo°Ý] ¸÷¨D¤½¦¡¤Ï±À

¦U¦ì¦Ñ®v¦n

¤p§Ì¦³­Ó¤p¤p°ÝÃD·Q½Ð±Ð

T9=IF(ISNUMBER(R9),ROUND((O9-O8)*1000*ASIN(((R9-P9)-(S9-Q9))/50000),2),"--- ")

³o¦ê¤½¦¡¤¤ §Ú·Q¨D±o S9 ªº¤Ï±À¤½¦¡

½Ð°Ý¤½¦¡­n¦p¦ó¼¶¼g?

¦pªG¥u¬O­nª¾¹D ·íT9¬°¤wª¾­È¡A¤Ï¨DS9­È®É¡A¥ç¥i¨Ï¥ÎEXCELªº¤u¨ã ¥Ø¼Ð·j´M¡C
EXCEL 2003 ¤u¨ã¦C - ¤u¨ã - ¥Ø¼Ð·j´M
¥Ø¼ÐÀx¦s®æ: T9
¥Ø¼Ð­È:  ¶ñ¤J§A­nªº­È
ÅܼÆÀx¦s®æ: S9
°õ¦æ«á¡AS9´N·|¦Û°Ê¶]¥X§A­nªº¤Ï±À­È
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦pªG¥u¬O­nª¾¹D ·íT9¬°¤wª¾­È¡A¤Ï¨DS9­È®É¡A¥ç¥i¨Ï¥ÎEXCELªº¤u¨ã ¥Ø¼Ð·j´M¡C
EXCEL 2003 ¤u¨ã¦C - ¤u¨ã - ¥Ø¼Ð·j´M
¥Ø¼ÐÀx¦s®æ: T9
¥Ø¼Ð­È:  ¶ñ¤J§A­nªº­È
ÅܼÆÀx¦s®æ: S9
°õ¦æ«á¡AS9´N·|¦Û°Ê¶]¥X§A­nªº¤Ï±À­È
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089


    ÁÂÁ¤j¤jªº«ü¾É  ¤£¥u¬O­n±o¨ì­È ÁٻݱN¤½¦¡¤Ï¼g ®M¥Î¦b¦U­Ó¤u§@ªí¤W

TOP

T9=IF(ISNUMBER(R9),ROUND((O9-O8)*1000*ASIN(((R9-P9)-(S9-Q9))/50000),2),"--- ")
ª½±µ¤Ï±À¤½¦¡§Ú¤£·|¡A¦Ó¥B·|¦³ºë«×®t²§ ROUND(....,2)
¥i¥H²¤Æ¤è¦¡¡A´N¬O±N¤wª¾­È(O9 O8 R9 P9 Q9)±a¤J²¤Æ(xx yy ¬°¤wª¾­pºâ­È)
T9 = xx*ASIN(yy*S9+zz)
S9 = (SIN(T9/xx)+zz)/yy
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦p¤£¦Ò¼{¥|±Ë¤­¤J»~®t¥i¸Õ¤@¸Õ¤U¦C¤½¦¡
S9=R9-P9+Q9-(3*pi()*T9/((O9-O8)*1000))*50000

TOP

§Ú¤Ï¾Éªº¤£¤Ó¤@¼Ë
S9 = R9-P9+Q9-SIN(T9/((O9-O8)*1000))*50000
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD