Factoring

[Cole]

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

 

[Gary Brown]

= 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
[email protected]
If this post was helpful to you, please select ''YES'' at the bottom of the
post.