LinkBack URL
About LinkBacks
Good afternoon all.
I want to know if Excel contains a function that calculates the circumference of an ellipse. Alternately, is there a formula developed by anyone that can do the same?
Thanks in advance
Good afternoon all.
I want to know if Excel contains a function that calculates the circumference of an ellipse. Alternately, is there a formula developed by anyone that can do the same?
Thanks in advance
Hi grenee and welcome to the forum,
Is this what you are looking for?
http://www.mathsisfun.com/geometry/e...perimeter.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for the quick response.
not really the response I am seeking. I don't want to calculate on the internet, I want to enter 2 values in an excel sheet which has the formula built in that give the results automatically
Using Ramanujan's approximation at Marvin's link,
Row\Col C2: =PI() * (A2+B2) * (1 + 3*(A2-B2)^2 / (A2+B2)^2 / (10 + SQRT(4 - 3*(A2-B2)^2 / (A2+B2)^2)))
Entia non sunt multiplicanda sine necessitate
Thank you.
Is it possible to have the formula in a copy and paste format, to copy from the forum and paste into me excel sheet? because in the given formula it seems like I would have to know some maths
Ok.
I got it done. Thanks very much
I did copy and paste but I realize that I was to use the column letters on my sheet rather than the ones I copied as they did not correspond in location.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks