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

Assuming the circumference is in C1...

=C1/(2*PI())

--
Rick (MVP - Excel)


"joelhmiller" wrote in message
...
how do i create a formula to find the radius (circumference=2*3.14r) if i
have the circumference?

On Feb 11, 7:44*pm, joelhmiller
wrote:
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()

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" wrote in message
...
how do i create a formula to find the radius (circumference=2*3.14r) if i
have the circumference?

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


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"joelhmiller" wrote:

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