Hi Sergey,

Thats pretty close and works most of the time. 7 does not work. But I could double check the lower x higher factors and if the result is under the original number, increment the lower value. What do you think?


>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?