Explanation
In geometry, the circumference of a circle with radius (r) is defined by the following formula: =2πr
The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with the PI function, which returns the number 3.14159265358979, accurate to 15 digits.
=PI() // returns 3.14159265358979
Therefore, the formula to calculate the circumference of a circle with a radius of 3 is:
=2*PI()*3 // returns 18.85
And the formula to calculate circumference based on the radius values in column B, is:
=2*PI()*B5
Related formulas
Area of a circle
In geometry, the area enclosed by a circle with radius (r) is defined by the following formula: πr 2 The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with the PI function , which returns the number 3...
Area of a triangle
In geometry, the area enclosed by a triangle is defined by this formula: where b represents the base of the triangle, and h represents the height, measured at right angles to the base. In Excel, the same formula can be represented like this: A=b*h/2 So, for example, to calculate the area of a...
Circumference of a circle
In geometry, the circumference of a circle with radius (r) is defined by the following formula: =2πr The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with the PI function , which returns the number 3...
Pythagorean theorem
The Pythagorean theorem is a key principle in Euclidean geometry. It states that the square of the longest side of a right triangle (the hypotenuse) is equal to the sum of the squares of the other two sides. The theorem is written as an equation like this: a 2 + b 2 = c 2 When any two sides are...
Related functions
PI Function
The Excel PI function returns the value of the geometric constant π (pi). The value represents a half-rotation in the radian angle system. The constant appears in many formulas relating the circle, such as the area of a circle....
