Excel Formatting

[Mr. Yoder]

I need to have the result of a formula always show up with 0 decimals and always round up. Any suggestions? I realize it may be under the Custom formatting, but have not been able to figure it out. Thank you.

 

[Becky]

Hi Mr Yoder - welcome to the forums

You need to use the following formula: =roundup(number,num_digits)

Number is any real number that you want rounded up.
Num_digits is the number of digits to which you want to round number.

• If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
• If num_digits is 0, then number is rounded up to the nearest integer.
• If num_digits is less than 0, then number is rounded up to the left of the decimal point.

Hope this helps!

Becky