Smallest Number Divisor

[ionelz]

Hi,

If Number=16.3 then I want INT(16.3) so result should be 2
If Number=21 then result should be 3
If Number=25 then result should be 5
......

Thank you

 

[AhoyNC]

See attached link.

Excel formula to show smallest divisor of a number

So far I was able to print number if it is prime or "" otherwise: =IF(A2=2,"Prime",IF(AND(MOD(A2,ROW(INDIRECT("2:"&ROUNDUP(SQRT(A2),0))))<>0),A2,"")) Is it possible to change formula to...

superuser.com

 

[Cubist]

Try:
(Editied)

Book1
	A	B
1	16.3	2
2	21	3
3	25	5
4	29	29
5	29.2	29
Sheet4

Cell Formulas
Range	Formula
B1:B5	B1	=LET(s,SEQUENCE(SQRT(A1),,2),XLOOKUP(0,MOD(INT(A1),s),s,INT(A1)))