ROUNDDOWN function

Copper Contributor

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?

 

My formula is =SUM(L3/1.09)

 

Where in there do I insert the ROUNDDOWN to get it to work properly?

 

Thank you in advance!

2 Replies

Perhaps

=ROUNDDOWN(L3/1.09,2)

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