Welcome to the Board!
Here is VBA code that will do what you want. Simply right-click on the sheet tab name (at the bottom of the screen) that you want to apply this code to, select "View Code", and paste this VBA code to the resulting VB Editor window:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng1 As Range, cell1 As Range
Dim rng2 As Range, cell2 As Range
' See if updated cells fall in 1st desired range
Set rng1 = Intersect(Target, Range("E25:E33"))
' Loop through all cells changed and apply formula
If Not rng1 Is Nothing Then
For Each cell1 In rng1
Application.EnableEvents = False
cell1.Value = 0.88 - cell1.Value
Application.EnableEvents = True
Next cell1
End If
' See if updated cells fall in 2nd desired range
Set rng2 = Intersect(Target, Range("E34:E34"))
' Loop through all cells changed and apply formula
If Not rng2 Is Nothing Then
For Each cell2 In rng2
Application.EnableEvents = False
cell2.Value = 0.86 - cell2.Value
Application.EnableEvents = True
Next cell2
End If
End Sub
Then, test it out by entering in some values and seeing what happens.
Note that you mentioned two ranges. You said E34 for your second one. You didn't say where that one should end, so I only have it as one cell, but you can easily modify that. You can see that you can easily add more blocks of similar code if you have more ranges.