Check if result is an integer?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Irdanwen - 25 Oct 2006 10:42 GMT

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

Reply to this Message

Niek Otten - 25 Oct 2006 10:48 GMT

=MOD(A1,1)=0

or

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|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

Reply to this Message

Bob Phillips - 25 Oct 2006 12:30 GMT

=A1=INT(A1)

Signature

HTH

Bob Phillips

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

> 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

Reply to this Message