I have cell D6 where I can enter values from 500 and increasing by 50. In cell G9 the value of cell D6 + 52 + 10 comes.
Now I would like that if the value in cell D6 is less than 600 that cell G9 automatically gets a value of 700. I had created a program code but that does not seem that easy.
Sub Upper bar ()
If D6 <650 Then
G9 = 700
End If
End Sub