The following code is attempting to check the conditon of the value of a cell.
If the value is less than ".108" I want to show the difference.
If the value is greater than ".110" I want to show the difference.
I think my problem right now is, if condition one is met condition two over rides condition one. (or vice~versa).
How can I make this work?
![]()
Sub check_L() Selection.NumberFormat = "0.0000" 'Set decimal places Range("L9").Select If Range("C9") <= "0.108000" Then Range("L9").Value = Range("C9").Value - "0.108000" '(Difference of) End If Range("L9").Select If Range("C9") >= "0.110000" Then Range("L9").Value = Range("C9").Value - "0.110000" '(Difference of) End If If Range("L9").Value = "0" Then 'If value = .0000 then make blank Range("L9").Value = "" End If End Sub
Bookmarks