About composed numbers

**RazBoss** · 02-15-2009, 01:34 PM

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:

Please Login or Register  to view this content.

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)

**shg** · 02-15-2009, 01:49 PM

If A1 contains a number, then this formula (confirmed with Cntrl+Shift+Enter, not just Enter)

=MAX(IF(MOD( A1 / ROW(INDIRECT("1:" & INT(SQRT(A1)) ) ), 1) = 0, ROW(INDIRECT("1:" & INT(SQRT(A1) ) ) ) ) )

returns the largest factor (not necessarily prime).

**RazBoss** · 02-15-2009, 02:30 PM

Thanks so much, it's useful for me!
But is there any formula with i can get all the factors (separated with commas or any signs)?

**martindwilson** · 02-15-2009, 02:34 PM

http://people.revoledu.com/kardi/tut...rimeFactor.htm
has a tutorial and a downloadable workbook (dont forget to turn iteration on in the downloaded work book