Calculating circumference

[Clayton King]

I'm sure this is simple, but I can't find it anywhere. I have the diameter of a circle and want to calculate the circumference. What's the formula?

 

[Frank Kabel]

Hi Clayton

circumference = 2 * Pi * radius

in Excel use the function PI(), so for your example
=2*(diamter/2)*PI()

Frank

 

[Ron Rosenfeld]

in Excel use the function PI(), so for your example
=2*(diamter/2)*PI()

Which is the same as

=diameter/Pi()




--ron

 

[Frank Kabel]

Which is the same as

=diameter/Pi()

Hi Ron

Definetly should stop working right now for not seeing this (haven't
calculated circumferences for years, though...)

Greetings
Frank

 

[Ken Wright]

LOL - Not quite Ron

=diameter/Pi()

Maybe diameter*Pi() though

 

[Ron Rosenfeld]

Maybe diameter*Pi() though

Ya know, I was thinking PI() * D, and then I saw Frank's post and got confused.

That's my story and I'm sticking to it <ggg>


--ron

 

[Ron Rosenfeld]

Hi Ron

Definetly should stop working right now for not seeing this (haven't
calculated circumferences for years, though...)

I think we should both stop working. I was thinking Pi()*D and then saw your
post. So I had to be a wise-ass and it came back and bit me (as Ken pointed
out).


--ron

 

[Ken Wright]

rotflmao

 

[Frank Kabel]

I think we should both stop working. I was thinking Pi()*D and then
saw your post. So I had to be a wise-ass and it came back and bit me
(as Ken pointed out).

o.k. lets stop working though I think my boss will disagree

Have a nice weekend
Frank

 

[Ken Wright]

Nahhh - It's Sunday - The Boss will be asleep anyway

 

[Norman Harker]

Hi Ken!

It's only PI*Diameter on working days. On Sundays / is having a rest.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ken Wright]

I'd prefer Sunday.Resize(1, 7).value = "Rest"