G Guest Mar 11, 2006 #1 I am trying to use a divisibility test in a formula to determine if the answer comes out as a whole number or not.
I am trying to use a divisibility test in a formula to determine if the answer comes out as a whole number or not.
N Nigel Mar 11, 2006 #2 use the Modulus function that returns zero for the 'whole' number test you require e.g.......... =IF(MOD(A1,B1)>0,"Non Divisible","Divisible")
use the Modulus function that returns zero for the 'whole' number test you require e.g.......... =IF(MOD(A1,B1)>0,"Non Divisible","Divisible")
