HI I have this at the moment

Range("x3") = data1.Value
Range("x4") = data2.Value

and in ranges y3 to y4 I have this formula in them =mod(x3,0.25). what i want to do is instead of putting the data on to a spread sheet and then seeing if its 0 or .25 or.50 or .75 is there not a way i could just use some vb code.

I hope this is easly understanderable.

thanks in advance