radius formula

[joelhmiller]

how do i create a formula to find the radius (circumference=2*3.14r) if i
have the circumference?

 

[Rick Rothstein]

Assuming the circumference is in C1...

=C1/(2*PI())

 

[joeu2004]

how do i create a formula to find the radius (circumference=2*3.14r)
if i have the circumference?

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()

 

[Mike Middleton]

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

 

[Shane Devenshire]

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()