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.

=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.

=IF(MOD(A1,1)=0,"whole number","not whole number")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"David Biddulph" <groups [at] biddulph.org.uk wrote in message ...
| =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.
|
|