Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of Numercials to Figure | Excel Worksheet Functions | |||
Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
How to .. | Excel Discussion (Misc queries) | |||
excel | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |