Need help with my sum check code

[yayayken]

Hello,

I am trying to do a sum check here and below is what I put:

Sub exercise()

' sum check
If Application.WorksheetFunction.Abs(Sum(Range("A:A"))) > 0.001 Then
MsgBox ("Good to Go")
Else
MsgBox ("Failed")
End If

End Sub

I basically want to make sure the absolute value of the sum result to be less than 0.001

Any help is appreciated.

[Keebellah]

Hi please use the code markers when placing code without the spaces are is just to show the code separator
[ code ]


[ / code ]

code goes here

Please Login or Register  to view this content.

And what is exactly your question? absolute value? ABS(the value) returns the absolute value but what do you mean with the question?

[yayayken]

Apologize for the confusion, I want to do a sum check on column A to make sure the sum result is less than 0.0001 and more than -0.0001

[Keebellah]

You can never compare an absolute value < or > than since an absolute value is that no negative
So just compare if the sum range if it's in between those values or outside, so >= <= or similar.

[shg]

Please Login or Register  to view this content.