´£¥Ü®Ø°ÝÃD

myleoyes

¦U¦ì«e½ú§A­Ì¦n!
         Àx¦s®æ(®æ¦¡¦Ê¤À¤ñ) O1 Åã¥Ü -92.611%
         «ö¶s( ) MsgBox "¥»¦¸¤ÀªR³ø¹S²v¬°  " & [O1] & Chr(37)
         ´£¥Ü®Ø«oÅã¥Ü ¥»¦¸¤ÀªR³ø¹S²v¬° -0.92611%
         ¦Ó«DÅã¥Ü ¥»¦¸¤ÀªR³ø¹S²v¬° -92.611%
         ½Ð°Ý³oµ{¦¡¦p¦ó­×§ï?
         ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!

myleoyes

¦^´_ 4# Hsieh
°¸¹³«e½ú!ÁÂÁ¦A¤T!!

Hsieh

¦^´_ 3# myleoyes

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 26 Or Target.Row < 3 Then Exit Sub
[Z1] = "=IRR(" & Range([Z3], Target).Address & ",-10%)"
End Sub

myleoyes

¦^´_ 2# Hsieh
°¸¹³«e½ú!ÁÂÁÂ!!¦A¤@°ÝÃD½Ð±Ð
      Z1=IRR(Z3:Z8,-10%)
      ·íÂI¿ïZ20®Éµ{¦¡±NZ1¤½¦¡
      Åܦ¨Z1=IRR(Z3:Z20,-10%)
      ¤]´N¬O»¡ÂI¿ïªº¦C¼Æ§Y¬°
      ¤½¦¡µ²§ô¦C¼Æ½Ð°Ýµ{¦¡¥i¥H¿ì¨ì¶Ü?
      ½Ð¦A³Â·Ð±Ð¾ÉÁÂÁ¦A¤T!!

Hsieh

¦^´_ 1# myleoyes


    MsgBox "¥»¦¸¤ÀªR³ø¹S²v¬°  " & [O1].Text & Chr(37)