Excel Formulas to Calculate the Surface Area of a Sphere ~ Quickly!!
Tags: excelformula, excelformulas
Published: 2021-07-02 04:48:49

---
title: Excel Formulas to Calculate the Surface Area of a Sphere ~ Quickly!!
published: true
date: 2021-06-27 16:55:02 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-sphere/
---

A sphere is defined as the set of points that are all the **same distance (r)** from a given point in a three-dimensional space. In this article, we will show the formulas to **find out the surface area of a sphere in Excel**. Let’s get them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Surface area of a sphere](https://geekexcel.com/wp-content/uploads/2021/06/Surface-area-of-a-sphere.png)](https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-sphere/surface-area-of-a-sphere/#main)<figcaption id="caption-attachment-48038">The surface area of a sphere</figcaption>

## Generic Formula:

- If you want to calculate the surface area of a sphere in Excel, you can use the below formula.

**=4\*[PI](https://geekexcel.com/how-to-use-excel-pi-function-in-office-365-with-examples/)()\*A1^2**

## Syntax Explanations:

- **PI**  – In Excel, the **[PI function](https://geekexcel.com/how-to-use-excel-pi-function-in-office-365-with-examples/)** helps to return the value of the constant π (3.14159265358979).
- **A1**  – It represents the input value.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- Here, we will enter the input values in **Column B**.
- Now we are going to find out the surface area of the sphere.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/06/Input-Range-15.png)<figcaption id="caption-attachment-48040">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-93.png)<figcaption id="caption-attachment-48039">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result1-13.png)<figcaption id="caption-attachment-48037">Result</figcaption>

## Closure:

From this tutorial, you can get some clarifications on how to **calculate the surface area of a sphere in Excel**. I hope this helps. Feel free to ask back any **questions** and let us know how it goes.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Calculate the Distance in 2D ~ Quick Solutions!!](https://geekexcel.com/excel-formulas-to-calculate-the-distance-in-2d/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Area of a Parallelogram ~ Quickly!!](https://geekexcel.com/excel-formulas-to-calculate-the-area-of-a-parallelogram/)**
- **[Excel Formulas to Calculate the Surface Area of a Cylinder ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-cylinder/)**