how can i factorise numbers on excel?
 

how can i factorise numbers on excel e.g. get all the factors of the number i
input?

Sam,

Do you want the prime factors?

12 = 2,2,3

or all possible factors?

12= 1,2,3,4,6,12

HTH,
Bernie
MS Excel MVP


"Sam" wrote in message
...
how can i factorise numbers on excel e.g. get all the factors of the
number i
input?

"Sam" wrote in message
...
how can i factorise numbers on excel e.g. get all the factors of the
number i
input?

You need some VBA code. You will find it in the link below
http://support.microsoft.com/?kbid=202782

/Fredrik