I am new in the whole universe of excel, but i understand how to make a formula that shows if a number is prime or not:
I want to know if there is a formula that shows (if the number is composed) from what numbers is composed (like 45=3*3*5)IF(A1>65536,"Error",IF(A1<1,"Error",IF(A1=1,"Composed",IF(SUMPRODUCT((MOD(A1,ROW(INDIRECT("1:"&A1)))=0)+0)>2,"Composed","Prime"))))
Bookmarks