how can i round up Integers for the greater decimal number in excel?

Question

ex 2.56+ 3.25+4.5 if I hide the decimal it will give you 3+3+5 but when you add in excel it give the sum of hiden decimals. please let me know the formula for round up integers

Answer 1

If you always want to round the numbers up rather than rounding them to the nearest whole number, the function is ROUNDUP. You need to give it the number to round, and the number of decimal places to round to. For example, ROUNDUP(3.25, 0) returns a value of 4. Zero decimal places gives you a whole number.

Answer 2

In a separate column, style "=INT(", spotlight the 1st cellular, close the parentheses and hit enter, and drag that formula down for as many cells as you're able to be able to desire to transform. additionally, INT "lops off" the fractional area of useful numbers only high-quality, even though it rounds down any detrimental numbers (-2.a million turns into -3). to truly truncate the decimal of ~any~ quantity, use TRUNC particularly of INT. Edit: ROUNDDOWN seems to be the appropriate comparable as TRUNC, so use that in case you choose.