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