# Need help with rounding in Excel

**URL:** <https://boards.straightdope.com/t/need-help-with-rounding-in-excel/401707>\
**Category:** Factual Questions\
**Created:** [April 26, 2007, 7:59am UTC](https://boards.straightdope.com/t/need-help-with-rounding-in-excel/401707 "2007-04-26T07:59:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dog80](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@Dog80](https://boards.straightdope.com/u/Dog80)\
**Post date:** [April 26, 2007, 7:59am UTC](https://boards.straightdope.com/t/need-help-with-rounding-in-excel/401707/1 "2007-04-26T07:59:53Z")

</div>

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? 🙂

---

<div class="post-metadata">

**Author:** ![One\_And\_Only\_Wanderers](https://avatars.discourse-cdn.com/v4/letter/o/838e76/32.png) [@One\_And\_Only\_Wanderers](https://boards.straightdope.com/u/One_And_Only_Wanderers)\
**Post date:** [April 26, 2007, 8:04am UTC](https://boards.straightdope.com/t/need-help-with-rounding-in-excel/401707/2 "2007-04-26T08:04:31Z")

</div>

=round(cellref,-1)

---

<div class="post-metadata">

**Author:** ![Dog80](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@Dog80](https://boards.straightdope.com/u/Dog80)\
**Post date:** [April 26, 2007, 8:15am UTC](https://boards.straightdope.com/t/need-help-with-rounding-in-excel/401707/3 "2007-04-26T08:15:00Z")

</div>

[QUOTE=One And Only Wanderers]  
=round(cellref,-1)  
[/QUOTE]

😃😃😃😃 Thanks!