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
Steve