VBA处理吧,估计你不只用于D3单元格,而是整列
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 2 And Target.Count = 1 And Target.Column = 4 Then
If Target.Offset(0, -2) = "支出" Then Target.Value = Target.Value * -1
End If
End Sub
VBA处理吧,估计你不只用于D3单元格,而是整列
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 2 And Target.Count = 1 And Target.Column = 4 Then
If Target.Offset(0, -2) = "支出" Then Target.Value = Target.Value * -1
End If
End Sub