Conversation

Replying to
An Excel 365 formula for returning the factors of a number. If none are found, it returns the "Prime number" message. Assuming the value is situated in cell A1: =LET(x,SEQUENCE(ROUNDDOWN(A1/2-1,0),,2),FILTER(x,MOD(A1,x)=0,"Prime number"))
2
Show more replies