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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks