Need help with rounding in Excel

Factual Questions
1

I tried the rounding functions in Excel but couldn’t achieve the desired outcome.

I want a function that rounds to the nearest decade, eg. 656.46 would become 660.00 and 262.53 would become 260.00.

Any ideas? :slight_smile:

2

=round(cellref,-1)

3

:smiley: :smiley: :smiley: :smiley: Thanks!