Forum Discussion

Debbie Brown's avatar
Debbie Brown
Copper Contributor
Jul 20, 2018

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?

 

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!

Formulas & Functions
Need Help

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jul 20, 2018

    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

Resources