Tom’s Tutorials For Excel: Evaluating Numbers as Being Whole or Decimal

Tom’s Tutorials For Excel: Evaluating Numbers as Being Whole or Decimal

There are times when you want to identify a number as being a whole number (such as 47) or a decimalized number (such as 23.5).

The picture shows three ways to apply this idea. You might want to identify a number as being whole or decimalized in a separate cell; or in the same cell, or disallow its attempt at entry.

In the TRUE or FALSE image, the formula in cell C3 is =MOD(B3,1)=0 to identify decimal numbers.
In the Data Validation image, that same formula rule is used to disallow a decimal upon entry.
In the Conditional Formatting image, the formula to identify decimal numbers is =MOD(B3,1)<>0.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
2 comments on “Tom’s Tutorials For Excel: Evaluating Numbers as Being Whole or Decimal
  1. Jon Peltier says:

    More elegant than my formula
    =INT(B3)B3

Leave a Reply

Your email address will not be published. Required fields are marked *

*