Hi,
Assuming H7 contains a % then:

If Abs((Range("b7").Value) - (Range("e7").Value)) <= Range("h7").Value *
Range("b7") Then

"ashw1984" wrote:

i am trying to test whether "e7" is within a "h7"% of "b7"
If Abs((Range("b7").Value) / (Range("e7").Value)) < ((Range("h9").Value) /
100) Then
can anybody suggest why this does not work
and/or how to do this thank's