Sub 判断2()
If Range("b3").Value > Range("b2").Value Then
If range(“b6”) = “多” and Range("b4")> Range("b3") then
Range("b5") = Range("b3") and Range("b7")=”多”
Else if range(“b6”) = “多” and Range("b4")<Range("b3") then
Range("b5") = Range("b3") and Range("b7")=”空”
Else if range(“b6”) = “空” and Range("b4")<Range("b3") then
Range("b5") = Range("b3") and Range("b7")=”空”
Else if range(“b6”) = “空” and Range("b4")>Range("b3") then
Range("b5") = Range("b3") and Range("b7")=”多”
End If
Else
Range("b4") > Range("b3")
End If
End Sub