Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#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" wrote in message ... how can i factorise numbers on excel e.g. get all the factors of the number i input? |
#3
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do insert page numbers in excel | Excel Discussion (Misc queries) | |||
Excel: Which numbers in a column equal a certain number (withou. | Excel Worksheet Functions | |||
print tickets with incrementing numbers in Excel ? | Excel Worksheet Functions | |||
How do I get Excel to correctly add a column of numbers that have. | Excel Discussion (Misc queries) | |||
How do i increase the size of numbers in a text in Excel. | Excel Worksheet Functions |