- ©«¤l
- 13
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 24
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2010-7-5
- ³Ì«áµn¿ý
- 2022-6-7
|
½Ð°Ý¦U¦ì±Æ¦C²Õ¦X°ÝÃD
§Ú·Qn°µ¦UºØ¼ÆȪº²Õ¦X«á,§P©w©Ò±oµ²ªG.¦ý¬O§ÚÁÙ¬O·Q¤£¥X«ç»ò¸Ñ.
A¡×$100
B¡×$50
C¡×$25
D¡×$5
¨Ò¦p:¤p©ú¨¤W¥u¦³¢C105,·Qn¶R¨ì¤W±A¡ãD(©ÎªÌA~nºØ)À\ÂI,¨CºØ³£¤£¯à«½Æ,¥i¥H¶R¨ìþ¨Ç²Õ¦X?
A=100-->O
AB=150-->X
ABC=175-->X
ABCD=180-->X
AC=125-->X
ACD=130-->X
AD=105-->O
B=50-->O
BC=75-->O
BCD=80-->O
BD=55-->O
C=25-->O
CD=30-->O
D=5-->O
Sub T1()
Range("E:F").Clear
MyC = 4
r = 3
AddX = 1
T = ""
m = 0
For i = 1 To MyC
For j = i To MyC
r = r + 1
If T = "" Then
T = Cells(1, j)
m = m + Cells(2, j)
Else
T = T & "+" & Cells(1, j)
m = m + Cells(2, j)
End If
Cells(r, 5) = T
Cells(r, 6) = m
Next j
T = ""
m = 0
Next i
End Sub |
-
-
T1.rar
(5.02 KB)
±Æ¦C²Õ¦X
|