"ss" wrote in message ...

ok so that rounded .758 to .75, which unfortunately didnt solve my problem. It has to
do with my gas bill/statement, it is 1p out.
All my figures on spreadsheet match the statement figures but for some reason excel is
adding an extra 1p and I am damned if I can find it.

See attached, I`ll get it eventually, if I auto sum the 3 figures concerned in a
separate cell it gives me the £15.90 (correct answer) but in the spreadshhet it returns
£15.91 (the CV figure is correct) I just cant work out where it is picking up the extra
1p.

https://imgur.com/cInzoSb


Both your spreadsheet and the bill only show values to 2 decimal places.

Whereas the figures on which these calculations are based, are to 3 or more
decimal places.

And so they could show a different final result, if rounding up is done at
different stages of the calculation

Possibly for accounting purposes the utilities may need to calculate bill
totals to 2 decimal places before applying VAT. If VAT is then applied to
this figure and the total again rounded up to 2 decimal places then this
may give a different result than if the rounding up is done only once on
the final total; as it is in your spreadsheet.


michael adams

....