I have the DV below that checks to only allow any value between 0.01
and 40000.00 in cell H10 provided a value exists first in J10.

The most peculiar thing is happening. If I type say 10 (a whole
number), it accepts - which is correct. If I then delete this value
and re-enter a 2 decimal value, it rejects it (but it shouldn't as its
valid)

Why is this happening

=AND(J10<"",H10=0.01,H10<=40000,MOD(100*H10,100)-
INT(MOD(100*H10,100))=0)