Factorization Question

Thanks for the quick response, apologies if it was unclear

If you calculate (x^2+7x-30) manually the answer hopefully is (x+10)(x-3) is
it possible to achieve this result with Excel?

Regards

Paul

"Bernard Liengme" wrote in message

> For a given value of X you can calculate the value of x² +7x -30 with
> =A1^2+7*A1-30 where A1 holds the value of x
>
> But this is not factorizing. Please clarify " to calculate the following"
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> [URL="http://people.stfx.ca/bliengme"]http://people.stfx.ca/bliengme[/URL]
> remove caps from email
>
> "Paul" wrote in message

>> Is it possible to calculate the following progmatically or with a
>> formula?
>>
>> (x^2+7x-30)
>>
>> Thanks in advance
>>
>
>
 >> Stay informed about: Factorization Question 

Hi. These should give the two solutions, where b=7, and c=-30

= (-b + Sqrt(Power(b,2) - 4*c))/ 2
= (-b - Sqrt(Power(b,2) - 4*c))/ 2

HTH
Dana DeLouis

Paul wrote:
> Is it possible to calculate the following progmatically or with a formula?
>
> (x^2+7x-30)
>
> Thanks in advance
>
>
 >> Stay informed about: Factorization Question 

Dana

Thanks very much, thats exactly what I wanted

Regards

Paul

"Dana DeLouis" wrote in message

> Hi. These should give the two solutions, where b=7, and c=-30
>
> = (-b + Sqrt(Power(b,2) - 4*c))/ 2
> = (-b - Sqrt(Power(b,2) - 4*c))/ 2
>
> HTH
> Dana DeLouis
>
> Paul wrote:
>> Is it possible to calculate the following progmatically or with a
>> formula?
>>
>> (x^2+7x-30)
>>
>> Thanks in advance
 >> Stay informed about: Factorization Question 

Hi. Glad to help.
You may be interested in the following...

[URL="http://en.wikipedia.org/wiki/Quadratic_equation"]http://en.wikipedia.org/wiki/Quadratic_equation[/URL]

= = =
Dana DeLouis


Paul wrote:
> Dana
>
> Thanks very much, thats exactly what I wanted
>
> Regards
>
> Paul
>
> "Dana DeLouis" wrote in message

>> Hi. These should give the two solutions, where b=7, and c=-30
>>
>> = (-b + Sqrt(Power(b,2) - 4*c))/ 2
>> = (-b - Sqrt(Power(b,2) - 4*c))/ 2
>>
>> HTH
>> Dana DeLouis
>>
>> Paul wrote:
>>> Is it possible to calculate the following progmatically or with a
>>> formula?
>>>
>>> (x^2+7x-30)
>>>
>>> Thanks in advance
>
>
 >> Stay informed about: Factorization Question 

On Mon, 2 Feb 2009 21:31:08 -0000, "Paul" wrote:

>Thanks for the quick response, apologies if it was unclear
>
>If you calculate (x^2+7x-30) manually the answer hopefully is (x+10)(x-3) is
>it possible to achieve this result with Excel?
>
>Regards
>
>Paul

You might be interested in a computer algebra program (free) called Maxima
[URL="http://maxima.sourceforge.net/"]http://maxima.sourceforge.net/[/URL]

With input of:

x^2+7*x-30

Factor --> (x-3)*(x+10)

and you can solve for 'x'

[x=-10,x=3]
--ron
 >> Stay informed about: Factorization Question 

On Feb 2, 1:32 pm, Dana DeLouis wrote:
>   = (-b + Sqrt(Power(b,2) - 4*c))/ 2
>   = (-b - Sqrt(Power(b,2) - 4*c))/ 2

Why use the POWER function instead of the exponential operator (^)?
In other words, why not b^2?

PS: Although the quadratic equation that you wrote above works for
Paul's polynomial, since you wrote it in the general form, I would
write the denominator as (2*a), where "a" is the coefficient of the
x^2 term. In Paul's case, a=1.

Note to Paul: What Dana provided are the "roots" of polynomial, not
the "factors". To answer your question: no, Excel itself cannot
provide the factors. "Is it possible" to do programmatically?
Probably; but I doubt that it's easy.
 >> Stay informed about: Factorization Question 

Paul,
Here I am being the nasty professor: you must learn the language of math.
What you wanted was to SOLVE the equation. Others have shown you how.
You may wish to visit
[URL="http://people.stfx.ca/bliengme/ExcelTips/QuadraticEqn.htm"]http://people.stfx.ca/bliengme/ExcelTips/QuadraticEqn.htm[/URL]
You will be asked to install a Microsoft Active-X component but this is
quite safe
best wishes
 >> Stay informed about: Factorization Question