J joelhmiller Feb 12, 2009 #1 how do i create a formula to find the radius (circumference=2*3.14r) if i have the circumference?
J joeu2004 Feb 12, 2009 #3 how do i create a formula to find the radius (circumference=2*3.14r) if i have the circumference? Click to expand... The correct formula is 2*pi*r. Don't use an approximation for pi (3.14). In Excel, if the circumference is in A1, the radius is: =A1 / 2 / PI()
how do i create a formula to find the radius (circumference=2*3.14r) if i have the circumference? Click to expand... The correct formula is 2*pi*r. Don't use an approximation for pi (3.14). In Excel, if the circumference is in A1, the radius is: =A1 / 2 / PI()
M Mike Middleton Feb 12, 2009 #4 joelhmiller - If the value of the circumference is in cell A1, in some other cell enter =A1/(2*PI()) - Mike Middleton http://www.MikeMIddleton.com
joelhmiller - If the value of the circumference is in cell A1, in some other cell enter =A1/(2*PI()) - Mike Middleton http://www.MikeMIddleton.com
S Shane Devenshire Feb 12, 2009 #5 the real question is how do you figure this out? You want to get everything except the R on one side of the equation, so: C = 2 * Pi() * R C/2 = Pi() * R You are dividing both sides by 2 C/2/Pi() = R You are dividing both sides by Pi()
the real question is how do you figure this out? You want to get everything except the R on one side of the equation, so: C = 2 * Pi() * R C/2 = Pi() * R You are dividing both sides by 2 C/2/Pi() = R You are dividing both sides by Pi()
