Need to convert formula into excel

[Chris E.]

Could someone please translate this formula into excel.

4 pi squared A /[B squared + (2 pi A )squared]

where A=cell A2 and B=cell B2

I would appreciate it.

Chris E.

 

[Norman Harker]

Hi Chris

Try:
=(4*PI()^2*A2)/(B2^2+(2*PI()*A2)^2)

Test on your data to make sure parentheses are correct.

 

[Chris E.]

Thanks for the response. But I am getting an error.

#DIV/0!

-----Original Message-----
=(4*PI()^2*A2)/(B2+2*PI()*A)^2

Could someone please translate this formula into excel.

4 pi squared A /[B squared + (2 pi A )squared]

where A=cell A2 and B=cell B2

I would appreciate it.

Chris E.

.

 

[Jacques Brun]

It should be

=(4*PI()^2*A2)/(B2^2+(2*PI()*A2)^2)

 

[Norman Harker]

Hi Vaughan!

Agreed! Both the formula and the "Aaagh"

 

[Chris E.]

I have am having different results that what I am being
told I should have at the following website.

http://www.math.cornell.edu/~dwh/papers/EB-DG/EB-DG-web.htm


Look at the end of the section "Curvature of Curves". Is
there something in that formula that is diffent. I am
getting .283043 in stead of 3.533.

-----Original Message-----

*Aaagh*

OK I think I've got it now:

=(4*PI()^2*A2)/(B2^2+(2*PI()*A2)^2)

Sorry that last effort was way off

Try:

=(4*PI()^2*A2)/(B2^2+2*PI()*A2^2)

=(4*PI()^2*A2)/(B2+2*PI()*A)^2

:

Could someone please translate this formula into excel.

4 pi squared A /[B squared + (2 pi A )squared]

where A=cell A2 and B=cell B2

I would appreciate it.

Chris E.

.

 

[Norman Harker]

Hi Chris!

Then you have quoted the formula wrong.

What are the values of A2 and B2 in your example?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

I have am having different results that what I am being
told I should have at the following website.

http://www.math.cornell.edu/~dwh/papers/EB-DG/EB-DG-web.htm


Look at the end of the section "Curvature of Curves". Is
there something in that formula that is diffent. I am
getting .283043 in stead of 3.533.

-----Original Message-----

*Aaagh*

OK I think I've got it now:

=(4*PI()^2*A2)/(B2^2+(2*PI()*A2)^2)

Sorry that last effort was way off

Try:

=(4*PI()^2*A2)/(B2^2+2*PI()*A2^2)


:

=(4*PI()^2*A2)/(B2+2*PI()*A)^2

:

Could someone please translate this formula into excel.

4 pi squared A /[B squared + (2 pi A )squared]

where A=cell A2 and B=cell B2

I would appreciate it.

Chris E.

.

 

[Dana DeLouis]

there something in that formula that is diffent. I am

I think he has it set up correctly. I believe the value is 1/r. So, when
he gets
r= 0.283043...

Just do 1/r

1 / 0.28304319967510216

3.533...

HTH
Dana DeLouis

Hi Chris!

Then you have quoted the formula wrong.

What are the values of A2 and B2 in your example?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

I have am having different results that what I am being
told I should have at the following website.

http://www.math.cornell.edu/~dwh/papers/EB-DG/EB-DG-web.htm


Look at the end of the section "Curvature of Curves". Is
there something in that formula that is diffent. I am
getting .283043 in stead of 3.533.

-----Original Message-----

*Aaagh*

OK I think I've got it now:

=(4*PI()^2*A2)/(B2^2+(2*PI()*A2)^2)

:

Sorry that last effort was way off

Try:

=(4*PI()^2*A2)/(B2^2+2*PI()*A2^2)


:

=(4*PI()^2*A2)/(B2+2*PI()*A)^2

:

Could someone please translate this formula into excel.

4 pi squared A /[B squared + (2 pi A )squared]

where A=cell A2 and B=cell B2

I would appreciate it.

Chris E.

.

 

[Dana DeLouis]

I guess if you are solving for r, one option could be to just invert the
equation that was given.

Perhaps something like this...


=A1^2/(4*PI()^2*B1) + B1

With a Height of 10 in A1, and R of 1 in B1, the above equation returns:

3.533029591

HTH
Dana DeLouis

I think he has it set up correctly. I believe the value is 1/r. So, when
he gets
r= 0.283043...

Just do 1/r

1 / 0.28304319967510216

3.533...

HTH
Dana DeLouis

Hi Chris!

Then you have quoted the formula wrong.

What are the values of A2 and B2 in your example?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

I have am having different results that what I am being
told I should have at the following website.

http://www.math.cornell.edu/~dwh/papers/EB-DG/EB-DG-web.htm


Look at the end of the section "Curvature of Curves". Is
there something in that formula that is diffent. I am
getting .283043 in stead of 3.533.


-----Original Message-----

*Aaagh*

OK I think I've got it now:

=(4*PI()^2*A2)/(B2^2+(2*PI()*A2)^2)

:

Sorry that last effort was way off

Try:

=(4*PI()^2*A2)/(B2^2+2*PI()*A2^2)


:

=(4*PI()^2*A2)/(B2+2*PI()*A)^2

:

Could someone please translate this formula into
excel.

4 pi squared A /[B squared + (2 pi A )squared]

where A=cell A2 and B=cell B2

I would appreciate it.

Chris E.

.

 

[Chris E.]

It works after all. Found out that there was more to it.
All is well. Thanks everyone.

Chris E.

-----Original Message-----
Hi Chris!

Then you have quoted the formula wrong.

What are the values of A2 and B2 in your example?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

I have am having different results that what I am being
told I should have at the following website.

http://www.math.cornell.edu/~dwh/papers/EB-DG/EB-DG- web.htm


Look at the end of the section "Curvature of Curves". Is
there something in that formula that is diffent. I am
getting .283043 in stead of 3.533.

-----Original Message-----

*Aaagh*

OK I think I've got it now:

=(4*PI()^2*A2)/(B2^2+(2*PI()*A2)^2)

:

Sorry that last effort was way off

Try:

=(4*PI()^2*A2)/(B2^2+2*PI()*A2^2)


:

=(4*PI()^2*A2)/(B2+2*PI()*A)^2

:

Could someone please translate this formula into excel.

4 pi squared A /[B squared + (2 pi A )squared]

where A=cell A2 and B=cell B2

I would appreciate it.

Chris E.

.

.