perfect
--- In [email protected], Dennis Brown <se...@...> wrote:
>
> Look at ceil() and also floor() for the inverse.
>
> BR,
> Dennis
>
>
> On Apr 21, 2009, at 12:51 PM, gmorlosky wrote:
>
> > What is a an easy way to RoundUp, instead of just Round ?
> > I take the square root of a number (say 85) and then it's square
> > root (9.2) and then round (9) to create a square matrix (total of
> > 81), which comes up short by 4 cells.
> > How can I RoundUp ?
> >
> > Here's my formula:
> > NumRowColumn = IIf(round(sqrt(CountAll))>16,16,round(sqrt(CountAll)));
> >
>