Need help on an excel if/then in Macro Solved/Closed

Question

I'm trying to create an If/Then in Macro for a cell which you input what GPM you want to use. The goal is to stop sales people from making errors and writing in too small of a GPM in the sales write up if working quickly. Say I want the minimum useable GPM to be 6% (not an actual figure, just example), but when a sales associate enters 5% (or less) by accident it automatically changes it to 6%.

If I'm doing it right the if/then statement is: =IF(G612<.06, .06)

But I can't get this to work for me in the way i want it to as mentioned above, or I just don't know how to use Macro. Can anyone help?

TIA

venkat1926 · Answer

I presume your column of interest is column G

right click the sheet tab and click view code 
in the window that comes up copy paste this EVENT CODE

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> Range("G1").Column Then Exit Sub
If Target < 0.06 Then Target = 0.06

End Sub
and save the file

In column G now enter some value <.06 e.g. .03 see what happens to that cell  enter more than .06 in some cell in column G. what happens?

give feedback

Need help on an excel if/then in Macro

1 response

Similar discussions

Subscribe To Our Newsletter!