Check if result is an integer?
 

I want to use Excel for calculation of primes. Is there a way to have Excel
check if the result of a division is an integer (i.e. a whole number, nothing
after the comma) or not? E.g. if 7/3 is integer then display yes else display
no.

I use Windows Office XP

Check if result is an integer?
 

=MOD(A1,1)=0

or

=IF(MOD(A4,1)=0,"yes","no")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Irdanwen" wrote in message ...
|I want to use Excel for calculation of primes. Is there a way to have Excel
| check if the result of a division is an integer (i.e. a whole number, nothing
| after the comma) or not? E.g. if 7/3 is integer then display yes else display
| no.
|
| I use Windows Office XP

Check if result is an integer?
 

=A1=INT(A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Irdanwen" wrote in message
...
I want to use Excel for calculation of primes. Is there a way to have
Excel
check if the result of a division is an integer (i.e. a whole number,
nothing
after the comma) or not? E.g. if 7/3 is integer then display yes else
display
no.

I use Windows Office XP