=IF(MOD(A1,5)=0,"divisible by 5","not divisible by 5")
--
David Biddulph

"MWG" wrote in message
...
I want to take a list of numbers and see if they are divisable by 5. If
they
are, then the division would return a whole number. I want to create an
IF
statement that lets let me know if the number was or was not a whole
number
and therefore divisible by 5. I can do the math but I can not find a
function that tells me if the results of the division were a whole number.