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.

 

Cheers

Catherine

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!