if declaration

[ashw1984]

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

[Toppers]

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
>
>

[Bob Phillips]

If Abs((Range("B7").Value * (1 + Range("H7").Value / 100))) >=
Range("E7").Value And _
Abs((Range("B7").Value * (1 - Range("H7").Value / 100))) <=
Range("E7").Value Then
MsgBox "yes"
End If


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashw1984" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>