Rounding

[Guest]

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

 

[Pete_UK]

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

 

[Bernd P]

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

Regards,
Bernd