View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MWG MWG is offline
external usenet poster
 
Posts: 1
Default How can I tell if a number is a whole number?

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.