Rounding full numbers (percentage) to nearest 10


I am trying to find a formula to round in full numbers (not decimal places).  I have a column that creates a percentage of "investment paid", and I want to round this to the nearest 10.  Ie; if the percentage result in the column is 59%, I would like this to display as 60%.  And conversely, if the percentage result is 61%, I want this to display as 60%.


(This is due to slight discrepancies in actual payments received due to bank fees and other adjustments, yet I need the percentage figure to be a round number to the nearest 10 for further use in additional calculations elsewhere in the sheet).


My current formula for working out the percentage is:  =SUM([Paid to Date]98 / [Committed Capital]98)


Can you please help.






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!