formula using Divisibility test

I am trying to use a divisibility test in a formula to determine if the
answer comes out as a whole number or not.

use the Modulus function that returns zero for the 'whole' number test you
require e.g..........

=IF(MOD(A1,B1)>0,"Non Divisible","Divisible")

--
Cheers
Nigel



"kspeedy28" <[email protected]> wrote in message
news:[email protected]...
> I am trying to use a divisibility test in a formula to determine if the
> answer comes out as a whole number or not.