excel vba Àx¦s®æ¿é¤J¤½¦¡ªº¤p°ÝÃD
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
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ÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 1# abba9817
ÁÂÁÂ!¤w¸g¦Û¦æ¸Ñ¨M¤F |
|
|
|
|
|
|