ªð¦^¦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 : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD