怎么用V表示很难么?

Question

怎么 用V 表示 很难么?

Answer 1

不是很难
在你要实现此功能的表下把下面的代码复制过去就行了
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Count = 1 Then
r = Target.Row
Cells(r,2) = Cells(r,1) * 0.02
End If
If Target.Column = 2 And Target.Count = 1 Then
r = Target.Row
Cells(r,1) = Cells(r,2) / 0.02
End If
End Sub