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))); >
