What function tests for whole number (no decimals)?

  • Thread starter Thread starter Andrew R
  • Start date Start date
A

Andrew R

How do you evaluate a cell that has two decimals places so that whole numbers
(no decimal places) is "True" and anything with values other that zeros to
the right of the dot evalute to "False"?
 
Try:

=INT(A1)=A1
or
=MOD(A1,1)=0

Does that help?
------------------
Regards,

Ron
Microsoft MVP (Excel)
(xl2003, XP Pro)
 

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

Trim varying decimals from column of numbers 9
format 9
formula for decimal point 4
Format for Whole number and 1 Decimal in same Cell 4
Change number format if value is zero 1
Problem entering numbers 3
Hiding certain decimal values 4
Decimal point in general format 1

Back
Top