G
Guest
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?
F
Frank Kabel
Hi Clayton
circumference = 2 * Pi * radius
in Excel use the function PI(), so for your example
=2*(diamter/2)*PI()
Frank
circumference = 2 * Pi * radius
in Excel use the function PI(), so for your example
=2*(diamter/2)*PI()
Frank
R
Ron Rosenfeld
Which is the same as
=diameter/Pi()
--ron
F
Frank Kabel
Ron said:
Hi Ron
Definetly should stop working right now for not seeing this (haven't
calculated circumferences for years, though...)
Greetings
Frank
K
Ken Wright
LOL - Not quite Ron
Maybe diameter*Pi() though
Maybe diameter*Pi() though
R
Ron Rosenfeld
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
R
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
K
Ken Wright
rotflmao
F
Frank Kabel
Ron said:
o.k. lets stop working though I think my boss will disagree
Have a nice weekend
Frank
K
Ken Wright
Nahhh - It's Sunday - The Boss will be asleep anyway
N
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.
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.
K
Ken Wright
I'd prefer Sunday.Resize(1, 7).value = "Rest"