Calculation function and formula of area, surface, circumference and volume in Excel

Source: Internet
Author: User

★ Calculate the square area and side length

If you need to calculate the area of a square, find a square with a long side. The following formula calculates the area of a square in the cell "side":

=side^2

If you need to calculate the perimeter of a square, multiply the length by 4. The following formula uses cell "side" to calculate the perimeter of a square

=side*4

★ Calculate the surface weave and perimeter of the rectangle

If you need to calculate the area of a short shape, use high times the bottom. The following formulas use cell height and base to calculate the area of a rectangle:

=height*base

If you need to calculate the perimeter of a rectangle, high times 2, plus a width times 2. The following formula uses cell height and width to calculate the perimeter of a rectangle.

= (height*2) + (width*2)

★ Calculate the area and perimeter of a circle

If you need to calculate the area of a circle, use the leather number pi multiplied by the square of the radius, the cell "radius" contains the rounded

Radius.

=PI () * (radius^2)

The radius of the circle equals one-second of the diameter.

If you need to calculate the circumference of a circle, use the factor pi multiplied by the diameter, use cell "diameter" to compute a circle of

Circumference.

=diameter*pi ()

The diameter of a circle is twice times the radius.

★ Calculate the Trapezoidal area

If you need to calculate a trapezoidal area, add two parallel sides, multiply by a high, and divide by 2. The following formulas use cells

"Side" and "height". Calculate the area of a trapezoid.

= ((side*2) *height)/2

★ Calculate the area of the triangle

If you need to calculate the area of a triangle, the bottom is multiplied by the height and then divided by 2. The following formula uses cell "base"

and "height" to calculate the area of a triangle.

= (base*height)/2

★ Calculate the surface area and volume of the sphere

If you need to calculate the area of a sphere, multiply the square of the sphere radius by pi, then multiply by 14. The following formula shows

The area of the sphere in which the radius of the sphere is placed in a cell named "Radiua".

=PI () * (radius^2) *4

★ If you need to calculate the volume of a sphere, multiply the cube with the radius of the sphere by π, then multiply by 4, then divide by 3. Under

The column formula calculates the volume of a sphere. In cell radius, the radius of the sphere is stored.

= ((radius^3) * (4*PI ())/3

★ Calculate the area and volume of the cube

If you need to calculate the area of a cube, multiply the square of the side length by 6. The following formula uses cell "side"

(edges containing cubes) to calculate the area of a square

= (side^2) *6

If you need to calculate the volume of a cube, find a side-length three-second square value. The following formula uses cell "side" to derive the volume of a cube

=side^3

★ Calculate the volume of a cylindrical body

If you need to calculate the volume of a cylinder, the square of the bottom radius is multiplied by pi, then multiplied by the height. The following formulas use cells

Lattice "radius" and "height" to calculate the volume of a cylinder.

= (PI () * (radius^2) *height)

★ Calculate the volume of a cone

Calculate the bottom area first, then multiply by the height and divide by 3. The following formula calculates the volume of a cone. Suppose the cell name is "width" (the width of the bottom), "height" (the height of the cone).

= (width*length*height)/3

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.