how can i factorise numbers on excel e.g. get all the factors of the number i input?
S Sam Apr 7, 2005 #1 how can i factorise numbers on excel e.g. get all the factors of the number i input?
B Bernie Deitrick Apr 7, 2005 #2 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, 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
F Fredrik Wahlgren Apr 7, 2005 #3 Sam said: how can i factorise numbers on excel e.g. get all the factors of the number i input? Click to expand... You need some VBA code. You will find it in the link below http://support.microsoft.com/?kbid=202782 /Fredrik
Sam said: how can i factorise numbers on excel e.g. get all the factors of the number i input? Click to expand... You need some VBA code. You will find it in the link below http://support.microsoft.com/?kbid=202782 /Fredrik
