MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula's


Posted by Eric on October 23, 2001 12:06 PM

Is there a way I can make formula's round up to the
next whole number?

Eric


Posted by Aladin Akyurek on October 23, 2001 12:07 PM

=ROUND(your-formula,0). (NT)

Posted by IML on October 23, 2001 12:10 PM


Try
=ROUNDUP(formula,0)

Posted by Mark W. on October 23, 2001 12:11 PM

=ROUND(2.1,0) will produce 2. In case you'd like
for it always to round up then use =CEILING(2.1,1).

Posted by Aladin Akyurek on October 23, 2001 12:16 PM

Type or Inattention:: =ROUNDUP(your-formula,0). (NT)

It's

=ROUNDUP(your-formula,0)