Number Rounding issue

  • Hi all,

    I have attached a spreadsheet which is a drummed down version of what im using but the relevant field and figures are shown. Quite simply Im have a rounding issue.

    I use an if statement to confirm that my totals are correct but the if statement considers the totals to more decimal placements that i want i.e 630,229.1614 and 630,229.1618. This should be considered the same i.e down to two decimal places.

    Even after I change the format it still screws up!! I have put the formula that matter next to the cells.

    Any help would be great


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!