Forum Discussion
PLEASE HELP _ How to Stop Rounding
Hi .. I have been using the same Excel template for my invoices for the past year and up until the past 3 weeks i havent had any issues. for some reason excel is rounding up some of my totals and it is causing me to invoice my client a penny over .. you would think a penny wouldnt be a big deal or even them to just under pay it by a penny but i am having to jump thru hoops to get them resubmitted. so please help me fix this.
ie 1 attached - the formula
=L21*M15
151.41 * $19.90
is showing the total to be $3,013.06 BUT it should total $3,013.05
ie 2 attached - the formula
=SUM(M20:M22)
$29,153.68 + $2,685.90 + $415.86
is showing $32,255.45 BUT it should total $32,255.44
1 Reply
MaryK912 Can't explain why this started to be problem only three weeks ago. It seems that Excel is just doing what it should. Your first calculation actually results in an amount of 3013.059. Formatting it as a Dollar with two decimals makes $ 3,013.06, following standard rounding practices. If you want Excel to display and (perhaps calculate further with this amount), you need to be specific by telling that it should round down to two decimals. The formula below, will do exactly that.
=ROUNDDOWN(<calculation>,2)The "error" in your second example is similar. You need to round down the result of each of the preceding calculations first.
