Need help on an excel if/then in Macro

[Solved/Closed]
Report
Posts
2
Registration date
Thursday March 18, 2010
Status
Member
Last seen
March 19, 2010
-
Posts
2
Registration date
Thursday March 18, 2010
Status
Member
Last seen
March 19, 2010
-
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

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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
Posts
2
Registration date
Thursday March 18, 2010
Status
Member
Last seen
March 19, 2010

That worked, thank you so much!