用IIF函数: Dim MAX As Integer,MIN As Integer MAX=IIF(a>b,a,b) MIN=IIF(a<b,a,b) a=MAX b=MIN如果用普通运算: Dim C As Integer if a<b then c=b b=a a=c end if
a=(abs(a-b)+a+b)/2 b=(-abs(a-b)+a+b)/2
高手如云啊,我也来一个普通运算的: Dim a As Long, b As Long Dim Max As Long, Min As Long a = 1 b = 2 Max = a * -(a > b) + b * -(a < b) Min = a * -(a < b) + b * -(a > b)
这个问题有点意思Dim a As Integer, b As Integer, c As Integer, d As Integer a = 1: b = 2 c = a + b d = (a < b) + 1 a = Abs(c * d - a) b = Abs(c * d - b)
Dim MAX As Integer,MIN As Integer
MAX=IIF(a>b,a,b)
MIN=IIF(a<b,a,b)
a=MAX
b=MIN如果用普通运算:
Dim C As Integer
if a<b then
c=b
b=a
a=c
end if
b=(-abs(a-b)+a+b)/2
Dim Max As Long, Min As Long
a = 1
b = 2
Max = a * -(a > b) + b * -(a < b)
Min = a * -(a < b) + b * -(a > b)
a = 1: b = 2
c = a + b
d = (a < b) + 1
a = Abs(c * d - a)
b = Abs(c * d - b)