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...
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.