ExcelBanter - Rounding Numbers

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/22471-rounding-numbers.html)

j41cam

Rounding Numbers

How do I set and change my own rounding rules so that numbers will - for
example - round up from .3 rather than the standard rule? Any ideas will be
helpful.

Duke Carey

Look in Help for the CEILING() function. You may find the FLOOR() function
interesting too.

"j41cam" wrote:

How do I set and change my own rounding rules so that numbers will - for
example - round up from .3 rather than the standard rule? Any ideas will be
helpful.

All times are GMT +1. The time now is 09:16 AM.