Trying to test for multiple of 5, or .5, .05, .005, .0005
hi, it helped remind of INT, but did not quite work; not sure what problem
is.
yesterday formula for getting off zero answer, but would think that:
=MOD(I17,$J$8) where I17 = .15 and $J$8 = 5
MOD should get .15/5=.03 remainder 0? getting: .15
my problem may include some of the simple use of MOD etc. new to me, but it
seems straight forward. just trying to get a TRUE condition if I pick
multiple of 5 or 10. thanks.
aside from that INT() might negate the use of .05 in cell $J$8
"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
|