Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: count negative cells

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Zero is even.... =MOD(0,2)=0


    Main Entry: 2even
    Pronunciation: 'E-v&n, -b&m
    Function: adjective
    Etymology: Middle English, from Old English efen; akin to Old High German eban even
    Date: before 12th century

    4 a : being any of the integers (as -2, 0, and +2) that are exactly divisible by two

  2. #12
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    here are some more ... on ZERO

    Edit: some material on Zero from the web

    Zero

    Zero is not a number. Zero is the absence of any value or number. It was the last of the decimal digits to be established in Western systems. You can count to zero by not counting.

    Mathematics represents a high level of abstraction attained by the human mind. In India, mathematics has its roots in Vedic literature which is nearly 4000 years old. Between 1000 B.C. and 1000 A.D. various treatises on mathematics were authored by Indian mathematicians in which were set forth for the first time, the concept of zero, the techniques of algebra and algorithm, square root and cube root.

    The concept of zero also originated in ancient India. This concept may seem to be a very ordinary one and a claim to its discovery may be viewed as queer. But if one gives a hard thought to this concept it would be seen that zero is not just a numeral. Apart from being a numeral, it is also a concept, and a fundamental one at that. It is fundamental because, terms to identify visible or perceptible objects do not require much ingenuity.

    But a concept and symbol that connotes nullity represents a qualitative advancement of the human capacity of abstraction. In absence of a concept of zero there could have been only positive numerals in computation, the inclusion of zero in mathematics opened up a new dimension of negative numerals and gave a cut off point and a standard in the measurability of qualities whose extremes are as yet unknown to human beings, such as temperature.

    Regards!


    _________________
    Yogi Anand

    Edit: Deleted inactive website from hardcoded signature

    [ This Message was edited by: Yogi Anand on 2003-01-19 13:16 ]

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    cool...

    thanks a lot guys

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •