Excel Formatting

M

Mr. Yoder

Joined
Apr 22, 2010
Messages
1
Reaction score
0
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.
 
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
 
Back
Top