Creating an automated macro that changes one cell value if another cell value is equal or less than a specific number

[TheCovenant75]

Hey, im new to vba coding and im trying to create an automated macro that constantly checks two cell values for my worksheet .
Basically i want it to check cell A12 and if its equal and or less than 250 to update Cell C12 with the number 250

I had tried to do it like this with what i learned from youtube videos (I'm sorry in advance if this hurts anyone here to read (>_<) )

Private Sub Worksheet_Change(ByVal Target As Range)

IF Sheets("Load Calculator").Cells(12, 1).Value => 250 then Sheets("Load Calculator").Cells(12, 3).Value = 250

End IF
End Sub

 

[kevin9999]

Please consider trying the following formula in cell C12:

=IFERROR(IF(A12="","",MAX(250,A12*B12)),"no valid value in A12")