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
Check out the Formula Handbook template!