+ Reply to Thread
Results 1 to 3 of 3

SUM not returning accurate value

  1. #1
    Registered User
    Join Date
    01-03-2015
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    40

    SUM not returning accurate value

    Hi all,

    i have a very strange problem. SUM isn't returning accurate value. In this example (attached) I am doing a simple calculation of 2 cells (67.34 x 0.04, which should be 2.69, but excel keeps returning rounded up value 3.00. No formatting options I have tried change this. Even if I simply the function at 0.04 or move it to a different cell, excel keeps showing 3.0. The calculation works correctly when I remove function from 0.04 value and simply type 0.04. Then excel shows 2.69 result.

    Thanks for any advice.
    Attached Images Attached Images

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: SUM not returning accurate value

    Try to replace your formula in Q2812 (or where is showing 0,04):

    =IF(M2812=0;"";IF(M2812/O2812<=0,005;0;ROUND(M2812/O2812,2)))

    Does it work? if doesnot, try to post an example.
    Quang PT

  3. #3
    Registered User
    Join Date
    01-03-2015
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    40

    Re: SUM not returning accurate value

    That worked. Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding Using Sumproduct - Not Returning Accurate Value
    By thecircularwriter in forum Excel General
    Replies: 6
    Last Post: 12-10-2014, 12:12 AM
  2. sum not accurate
    By MIAO in forum Excel General
    Replies: 5
    Last Post: 06-15-2012, 08:33 PM
  3. more accurate vlookup?
    By jlamannaphoto in forum Excel General
    Replies: 4
    Last Post: 10-11-2011, 11:50 AM
  4. Macros not accurate???
    By EXCELOST in forum Excel General
    Replies: 2
    Last Post: 12-08-2010, 12:49 PM
  5. Sumproduct-looking up are accurate
    By sanders in forum Excel General
    Replies: 4
    Last Post: 08-16-2006, 08:31 AM

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