ExcelBanter - Rounding in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding in Excel (https://www.excelbanter.com/excel-worksheet-functions/202671-rounding-excel.html)

trichey

Rounding in Excel

I am trying to round a cell either up to the nearest 500 or down to the
nearest 500...any suggestions. My current formula is =ROUNDUP(A2*1.3,500).
Help?

Mike H

Rounding in Excel

Try

=MAX(A1,mround(A1,500))

The max bit would make 0 - 249 sray as that number but if you want these to
be zero then use

=mround(A1,500)

If you get a #name error then
Tools|Addins
Check the analysis toolpack

Mike

"trichey" wrote:

I am trying to round a cell either up to the nearest 500 or down to the
nearest 500...any suggestions. My current formula is =ROUNDUP(A2*1.3,500).
Help?

Stefi

Rounding in Excel

Try this:
=FLOOR(A2,500)
=CEILING(A2,500)

Regards,
Stefi

€žtrichey€ ezt Ã*rta:

I am trying to round a cell either up to the nearest 500 or down to the
nearest 500...any suggestions. My current formula is =ROUNDUP(A2*1.3,500).
Help?

All times are GMT +1. The time now is 06:25 AM.