| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function tests for whole number (no decimals)?
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"? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function tests for whole number (no decimals)?
Try:
=INT(A1)=A1 or =MOD(A1,1)=0 Does that help? ------------------ Regards, Ron Microsoft MVP (Excel) (xl2003, XP Pro) "Andrew R" <Andrew wrote in message ... 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"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of Decimals Excel can Handle | Excel Discussion (Misc queries) | |||
| Whole Number and Decimals | Excel Discussion (Misc queries) | |||
| Displaying decimals that go in to a given number | Excel Discussion (Misc queries) | |||
| How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
| Average a group of tests for grade, some tests not taken by all. | Excel Discussion (Misc queries) | |||
Hybrid Mode
