可以,需要借助vba。右击工作表标签》查看代码》将下面的代码粘贴到右侧窗口中。Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
With Target
For Each c In Target.Cells
If .Column = 1 Then .Value = .Value / 1.17 '判断单元格是否为A列,如果是则将原值/1.17后填入单元格。
Next
End With
Application.EnableEvents = True...