+ Reply to Thread
Results 1 to 12 of 12

Numbers not calculating correctly

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    18

    Numbers not calculating correctly

    Using a formula to multiply cell C13, which has a value of 46.61, by cell C12, which has a value of 7.16, is giving me a result of 333.55. But if I manually multiply these numbers, I get a result of 333.73. Why are the results different? I've used "accounting" and "number" formatting with the same results. Thanks!

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Numbers not calculating correctly

    Look at value of C13

    type in blank cell
    =C13 = 46.61 if returns false then it is rounded visually maybe 46.6061111
    do it also to cell C12
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Numbers not calculating correctly

    That's strange. I created a new workbook and used 'General' and I got the total 333.7276
    Have you tried 'General'?

  4. #4
    Registered User
    Join Date
    05-24-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Numbers not calculating correctly

    Hi Vlady. Both returned False. What should I do next?

  5. #5
    Registered User
    Join Date
    05-24-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Numbers not calculating correctly

    Hi russkris. When I change the cells to General I get a total of 333.5455882

  6. #6
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Numbers not calculating correctly

    They are not rounded if you want you can round them

    eg.

    =round(C13,2) the 2 means two decimal so C13 - 46.61 , C12 7.16
    look also


    or
    truncate

    =trunc(C13,2) this will "cut off all numbers after two decimal... so you'll have C13 - 46.60 , C12 7.15

    =roundup
    =rounddown

  7. #7
    Registered User
    Join Date
    05-24-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Numbers not calculating correctly

    Thanks, Vlady. I'm trying to get the cell formula to equal 333.73. If I use your rounding method, is that what will happen?

  8. #8
    Registered User
    Join Date
    05-24-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Numbers not calculating correctly

    Using the formula =ROUNDUP(C13*C12,2) I still get 333.55 for a result.

  9. #9
    Registered User
    Join Date
    05-24-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Numbers not calculating correctly

    Actually, it just worked. I'm now getting 333.73. I had to roundup cells C11 and C12 too, not just the formula cell.

  10. #10
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Numbers not calculating correctly

    Round the cells first before multiplying..

    =roundup(C13)*Roundup(C12)


    **********it is better if the round will be used in "Inside" C12 and C13

    eg. in C12 = roundup(A1+B1,2) so it is automatically rounded up before computation in other cell

  11. #11
    Registered User
    Join Date
    05-24-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Numbers not calculating correctly

    Thanks, Vlady! That worked. I appreciate your help.

  12. #12
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Numbers not calculating correctly

    Your Welcome. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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