### Title

Rounding

### Post

I am trying to round up to the nearest whole number. The only thing that I have found in my searches is:

"To always **round** up to the next nearest integer, the calculation formula would be:**Round** (Number + .499999, 0)"

But if I were to add .499999 to 1.8, instead of rounding up to 2 the formula would force the calculated number above 2 making it round up to 3. How do I get around this?

Howdy JBizkit,

Keep your "real" numbers in one field (or set of fields as appropriate), and your rounded result in another. Only round the result, not the raw data. This will avoid the 'compounded rounding'.

PS. This holds true for XL, JMP, minitab and any other spreadsheet as well. Keep the raw data raw, cook the books somewhere else.

Enjoy the day!