SPHERE(Radius)
where,
Radius - represents the radius of sphere.
Related functions:-
SPHERE.SURFACEAREA() - returns the aum of all the areas of the shapes that cover the surface area of object.
SPHERE.VOLUME() - returns the amount of 3-dimensional space occupied by an sphere.
'
A sphere is the set of all points in three-dimensional space (R3) which are at distance r from a fixed point of that space, where r is a positive real number called the radius of the sphere.
SPHERE
Lets see an example in (Column1, Row2)
=SPHERE(R1C1)
The function returns the shape.
Consider an another example(Column1, Row3)
=SPHERE.SURFACEAREA()
It returns area of surface area of sphere(615.75216).
Consider an example in (Column1, Row4)
=SPHERE.VOLUME()
It returns volume of sphere(1436.75504).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 7 | |||
| Row2 |
Sphere: |
|||
| Row3 | 615.75216 | |||
| Row4 | 1436.75504 | |||
| Row5 | ||||
| Row6 |
| TABLE3 |