Results 1 to 4 of 4

sumation formula keeps creating a decimal that countifs formula won't read.

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2023
    Location
    USA
    MS-Off Ver
    2007
    Posts
    2

    sumation formula keeps creating a decimal that countifs formula won't read.

    Hello,

    I normally don't post on forums, but I feel i've researched everywhere and I am completely stumped and this point.
    If anybody could please help me, it would be greatly appreciated.

    I made a simple summation formula that finds the difference of 2 cells.
    Then my goal is to count all the numbers within a range of .70 to .79.

    Everything looks good, but for some reason on the last entry the formula is supposed to calculate : 6.64 - 5.94 = .70
    In the cell it displays .70. However, the countifs formula would not count it in the range of .70 to .79.

    So i copied and pasted the value in a different cell, only to find out that despite it showing .70, in the top it shows as .6999999.

    And i dont know how to correct it.
    I have tried all number formating and decimal formating and nothing seems to work. Furthermore, i find it strange that this only happens with 6.64 - 5.94, as all the other ones do not do this.

    The cell is question is c17.

    I am currently using excel 2007. (I know. it's old, but im poor).
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula of two 2-decimal numbers returns an extended decimal number
    By Matt Triplenichol in forum Excel General
    Replies: 1
    Last Post: 08-09-2022, 05:44 PM
  2. [SOLVED] converting a countifs referencing part of the formula to a indirect countifs
    By DEEARO in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2021, 03:17 PM
  3. [SOLVED] Creating a Clashing Grid - COUNTIFS and/or SUMPRODUCT Array Formula?
    By AliGW in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-06-2017, 09:36 AM
  4. Replies: 2
    Last Post: 06-29-2012, 07:52 PM
  5. Conversions of Decimal Feet to Decimal Inches - Formula??
    By shubhamdev in forum Excel General
    Replies: 2
    Last Post: 04-15-2012, 03:57 AM
  6. Sumation Formula
    By fish8590 in forum Excel General
    Replies: 3
    Last Post: 10-13-2011, 09:14 PM
  7. [SOLVED] Creating A sumation formula
    By Clinton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2005, 11:27 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1