Jos,
Try
? FLOOR(SQRT(lnNumber)), CEILING(SQRT(lnNumber))
>
>Given an integer, how do I find the 2 highest factors that produce that exact integer or the next nearest higher integer? i.e.
>
>1) Given 50 I would like 7 & 8 = 54. (7 x 7 = 49 would be too low)
>
>2) Given 36 I would like 6 & 6.
>
>Any easy calculation for that?
--sb--