I got your response about the floating point errors.
I tried a few numbers and I deduce that one should use the smallest
multiple of the cutoff value that results in a fractionless number? In
the case the OP asked for, the cutoff was .8, so the smallest multiple
of .8 that results in a whole number is 5. 10, 15 and 20 also result
in whole numbers, but they do not always return the correct result
with the formula (I am cloudy on why is this happening if you could
enlighten). Could it *ever* happen when using 5? I set a worksheet to
test it on 10000 random numbers ending in .8, and through refreshing
many many times, never saw any errors.
I tried to do this with .77 as the cutoff, so had to use 100 as the
smallest multiple to return a whole number -- and it doesn't -always-
work.
Is there a way to get it to work all the time with .77 or .719292 or
???
This maybe getting too far into minutia since the OP got his answer
long ago, but I appreciate further light you can shine on this.
If I were solving the original question before I had seen this INT and
MOD stuff, I would use a formula that looked at the decimal portion of
the formula, as many spaces as I wanted to look at, then either add 1
or add nothing to the whole number part depending on what the portion
was. BUT this is much more interesting.
Thanks
Dave