Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making a specific row number active from a cell entry | Excel Discussion (Misc queries) | |||
Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
How do I make a cell with vertical lines for number entry? | Excel Discussion (Misc queries) | |||
script to increase last number in cell entry for hyperlink | Excel Programming | |||
Confirm target cell is equal | Excel Discussion (Misc queries) |