View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smartin smartin is offline
external usenet poster
 
Posts: 915
Default How to confirm a cell entry is a whole number

Phil Hibbs wrote:
smartin wrote:
My understanding of the definition of "whole numbers" is "the set of
positive integers, including zero". If the OP meant "integer number",
then I agree to remove the Abs wrapper in the test, as you suggest.


The definition is ambiguous:
http://en.wikipedia.org/wiki/Whole_number

Phil Hibbs.


I find it unintuitive that a negative integer would be considered
"whole", but your point is well taken. I should not assume "whole
number" has a specific meaning in common parlance.

FWIW the definition I used was the one imposed upon me 30-odd years ago.
We were rigorously tested on our ability to place a number in the
correct domain(s) of counting numbers, whole numbers, integers, rational
numbers, irrational numbers and complex numbers. Visions of Venn
diagrams are flooding back to me.