factorization

[hemsleysut]

Anyone have any ideas about programming excel to return the factorization of a user-input number. There is a code for determining whether a number is prime or composite which could be part of the programming or do you think it better to store a large list of primes which could be used to test against the number.

 

[Richie(UK)]

Hi hemsleysut,

Have a look at the number 31 download on this page http://www.xl-logic.com/pages/vba.html . Does that help?