Trying to test for multiple of 5, or .5, .05, .005, .0005
ok, see some of: where MOD(0.15,.05)=0 comes up true still is not for my
bring forward cells, breaking this down i see:
focus: =MOD(I17,$J$8) is comming to .0000
but when put =0 after the formula, and checking formatting / answer: am
getting:
-.00000000000000000138777... etc
(using format cells, number, decimal places: 30)
ahhhh, guesse correct use of round: =ROUND(MOD(I17,$J$8),4)=0
seems to be getting it. thanks much
how do I "generically"?? round to .0000
"MartinW" wrote:
Hi Nastech,
Possibly this may do it.
=MOD(INT(I18),INT($J$8))=0
HTH
Martin
"nastech" wrote in message
...
hi, in trying to find multiple of 5, (for conditional formatting
purposes).
for multiple of 5 or .5, .05, .005, .0005 to mess it up: where
MOD(15,5)=0 works,
When I try to use external "calculated" cells for 15/5, FOR:
=MOD(I18,$J$8)=0 the remainder is not exactly 0., but
.00000000000000000433.., maybe there is another method? Tried FLOOR()
or
ROUND() does not work, thanks
I18 calculated to: 15
J8: 5
|