+ Reply to Thread
Results 1 to 3 of 3

formula giving wrong result sometimes?

  1. #1
    Registered User
    Join Date
    04-16-2008
    Posts
    63

    formula giving wrong result sometimes?

    Hello,

    I have made up a workbook to keep track of sales. It has the sale price plus shipping less fees and it works but one entry is giving a final amount which is off by a penny and I was wondering why.

    I have attached the workbook with the formulas used to get the results and highlighted the one that is giving the incorrect final amount. If I use a calculator the result is correct and there is no need to round up or down so I don't understand.

    Any assistance would be greatly appreciated.
    Attached Files Attached Files
    Last edited by lnjr; 08-13-2010 at 09:21 AM. Reason: solved

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: formula giving wrong result sometimes?

    its not wrong
    change your cell formats to number 4 decimal places and you will see why
    you could change D2 downwards to
    to
    =ROUND(A2*0.15,2)
    to get your expected result .
    your calculator is probably rounding
    Last edited by martindwilson; 08-13-2010 at 08:37 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    04-16-2008
    Posts
    63

    Re: formula giving wrong result sometimes?

    I entered the formula you gave me into column D and that works. I was doing the calculations by hand all the time and just figured that the formula I had entered would work - (especially since columns C & D gave the correct result without using the roundup formula) and could not figure out why 4.57 - .23 kept giving me an answer of 4.35 instead of 4.34.

    I should have tried using the round figure first.

    Thanks for the assistance. It is Greatly Appreciated.

+ 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