Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Factoring
Is there a function for factoring or prime factorization?
i.e. 45 = 3^2 * 5 165 = 5 * 11 * 3 If so, does it work with variables? i.e. x^2 - x - 6 = (x+2)(x-3) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Factoring
= 5 * 11 * 3
=sumproduct(A1,A2,A3) = 3^2 * 5 =(A1^2)*B1 x^2 - x - 6 = (x+2)(x-3) =(A1^B1) - A1 - C1 -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "Cole" wrote: Is there a function for factoring or prime factorization? i.e. 45 = 3^2 * 5 165 = 5 * 11 * 3 If so, does it work with variables? i.e. x^2 - x - 6 = (x+2)(x-3) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|