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)
