ExcelBanter - Rounding

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

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

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

GinGinW73

Rounding

Can I change my round function to round up if 5 or above and down if below 5?

Pete_UK

Rounding

That is what the ROUND function does, eg:

=ROUND(A1,0)

You might also like to look at ROUNDUP, ROUNDDOWN, CEILING, FLOOR,
INT, TRUNC functions in Excel Help.

Hope this helps.

Pete

On Oct 26, 2:54 pm, GinGinW73
wrote:
Can I change my round function to round up if 5 or above and down if below 5?

Bernd P

Rounding

=Round(A1,-1)
if I understand you correctly.

Regards,
Bernd

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