Less than numbers issue please help

[DKY]

I'm trying to do a conditional with some cells that are formatted like so.

Range("B" & i & ":S" & i).NumberFormat = "0"

(so that they show up as whole numbers)

and I'm running the If like so

If Range("R" & i).Value < "0.5" Then
color the row

the problem is that its catching the 0.5's and stuff but for some reason its not catching the 0.0833333 which in my math education is less than 0.5 but for some reason its not registering as less than 0.5. Does anyone know why?

[Tom Ogilvy]

try using the number 0.5 and not a string containing the characters 0 . 5

If Range("R" & i).Value < 0.5 Then

--
Regards,
Tom Ogilvy

"DKY" <[email protected]> wrote in message
news:[email protected]...
>
> I'm trying to do a conditional with some cells that are formatted like
> so.
>
> Range("B" & i & ":S" & i).NumberFormat = "0"
>
> (so that they show up as whole numbers)
>
> and I'm running the If like so
>
> If Range("R" & i).Value < "0.5" Then
> color the row
>
> the problem is that its catching the 0.5's and stuff but for some
> reason its not catching the 0.0833333 which in my math education is
> less than 0.5 but for some reason its not registering as less than 0.5.
> Does anyone know why?
>
>
> --
> DKY
> ------------------------------------------------------------------------
> DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
> View this thread: http://www.excelforum.com/showthread...hreadid=469586
>

[DKY]

That does the trick, thanks. I knew it would be something easy.