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

excel vba Àx¦s®æ¿é¤J¤½¦¡ªº¤p°ÝÃD

excel vba Àx¦s®æ¿é¤J¤½¦¡ªº¤p°ÝÃD

½Ð°ÝÀÀ§Q¥Î excel vba ½s¼gÀx¦s®æJ29ªº¤½¦¡¦p¤U
Sheets("°òª÷¤­½uÃÐ").Range("J29").Formula = "=IF($H29="", "", NORMINV($L$27, $J29, $O$1))"
¦ý°õ¦æ¥¨¶°®É.J29¤ºªº¤½¦¡¬ã§PªÅ¥Õªº²Å¸¹"",³£·|Åܦ¨",¨Ï¤½¦¡¥X²{¿ù»~(¦p¤U)
=IF($H29=", ", ROUND($H29*$K$1+$M$1,4))
½Ð°Ý¦p¦ó­×¥¿©O?..¦b¦¹¥ý·PÁÂ!

¦^´_ 1# abba9817

ÁÂÁÂ!¤w¸g¦Û¦æ¸Ñ¨M¤F

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD