- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 115
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-5-19
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-8-31 11:23 ½s¿è
¨S¬ÝÀ´³o¥y"³Ì¦n¯àºâ¥X¶V±µªñ ì D2 ¸ò D3 ªºÈ¶V¤p¶V¦n¥B¥²¶·¾ã¼Æ"
¥[¤J¤ñ¨Ò¨D°_ºâÈ- Sub yy()
- m = InputBox("¥Ø¼Ð", , 4175500)
- pr = m / ([C2] * [D2] + [C3] * [D3])
- k = Int([E2] * pr) + 1
- i = Int(k / [C2])
- y = (Val(m) - i * [C2]) / [C3]
- Do Until y <> 0 And y = Int(y)
- i = i - 1: y = (Val(m) - i * [C2]) / [C3]
- If i = 0 Then MsgBox "µLªk¨ú±o": End
- Loop
- [F2] = i: [F3] = y
- End Sub
½Æ»s¥N½X
metrostar305.rar (9.62 KB)
|
|