I have a table adds amounts as they are entered to the previous amount (a running total) which apparently when it adds £18.41 + £18.41 +£15.95 + £18.41 gives a running total of £71.17 rather than £71.18.
Does anyone know why?
Thanks
I can't reproduce that here:
However, it sounds as if there is some internal rounding going on that isn't evident from the way your values are displayed on your spreadsheet.
You might try increasing the Decimals to see if there are values in the other decimal places. If there are, you could try =ROUND([your value],2) to see if that eliminates the discrepancy.
SG
Here's mine. I set the number of decimal places in the £ columns to 2.
Try temporarily setting decimals for the Cost column to something large and see if you see values after the second decimal place. If you do, you may want to consider using ROUND in the formulas in the Cost Running Total column.
SG
You can see where the £18.41 comes from because the 3rd d.p is >5 likewise the £15.95 stays as it is. It just seems an odd way to add numbers where the number of decimal places has been set, it seems to have ignored that request as it were.
Also the formula in the Cost Running Total colmun is =IFERROR(IF(G6+E7>0,G6+E7,""),"") so where would I have to stick the ROUND function in that little lot?
You haven't "set" a number of decimal places unless you have used a ROUND function; you have just asked it to display a number of decimal places. That doesn't change the underlying number, which is what is used for the calculation.
Oh I see now. So do I need to ROUND the figure off befoe I apply the IFERROR formula or can I incorporate the ROUND function within the IFERROR formula?
Thanks
If you want the end result to always agree with the result expected from the (two decimal place) displayed values in the "Cost" column, you'll need to apply round to those values.
=IFERROR(IF(G6+E7>0,G6+E7,""),"")
becomes
=IFERROR(IF(G6+E7>0,ROUND(G6,2)+ROUND(E7,2),""),"")
Regards,
Barry
1 + 1 may not = 2!!
