Thread: if declaration
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ashw1984 ashw1984 is offline
external usenet poster
 
Posts: 10
Default if declaration

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