How can I tell if a number is a whole number?

M

MWG

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

Niek Otten

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Creating a Search using a combo box and then creating a report. 4
Page numbering with Merged Document and IF statements 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Need a formula for a descimal integer into a whole number 1
Duplicate pst, or is it? 0
How to paste this down? 3
Finding the right style field in VBA 0

Top