Forum Discussion
ROUNDDOWN function
I am using a spreadsheet with formulas to figure sales tax and am having issues with it rounding the figures up which is causing my accounting to be off. How do I get the formula to always round down...
Hi Debbie,
You don't have to use SUM function in your formula because SUM is usually used on a range of cells to sum its values, not on a single cell.
So, your original formula could look like this:
=L3/1.09
If you want always to round down the result of the formula to a specific number of decimals (let's say 2), you can modify the original formula as follows:
=ROUNDDOWN(L3/1.09,2)
If you don't want to see any decimals at all you may replace 2 with 0 as follows:
=ROUNDDOWN(L3/1.09,0)
Hope that helps
Regards