Try round(sqrt(CountAll)+0.5)).

--- In [email protected], "gmorlosky" <gmorlo...@...> 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)));
>


Reply via email to