---
title: "Square root in Excel: how to use the SQRT function"
description: "How to take a square root in Excel with SQRT or ^0.5: the distance between two points, cube roots and how to avoid the #NUM! error."
canonical_url: "https://excelsavvy.com/functions/sqrt"
meta:
  "og:description": "How to take a square root in Excel with SQRT or ^0.5: the distance between two points, cube roots and how to avoid the #NUM! error."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U3F1YXJlIHJvb3QgaW4gRXhjZWw6IGhvdyB0byB1c2UgdGhlIFNRUlQgZnVuY3Rpb24%2Cdescription_~SG93IHRvIHRha2UgYSBzcXVhcmUgcm9vdCBpbiBFeGNlbCB3aXRoIFNRUlQgb3IgXjAuNTogdGhlIGRpc3RhbmNlIGJldHdlZW4gdHdvIHBvaW50cywgY3ViZSByb290cyBhbmQgaG93IHRvIGF2b2lkIHRoZSAjTlVNISBlcnJvci4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_SQRT(number)%2Cp_Ii9mdW5jdGlvbnMvc3FydCI%2Cs_FZnK44t52i4e4KW_.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Square root in Excel: how to use the SQRT function"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U3F1YXJlIHJvb3QgaW4gRXhjZWw6IGhvdyB0byB1c2UgdGhlIFNRUlQgZnVuY3Rpb24%2Cdescription_~SG93IHRvIHRha2UgYSBzcXVhcmUgcm9vdCBpbiBFeGNlbCB3aXRoIFNRUlQgb3IgXjAuNTogdGhlIGRpc3RhbmNlIGJldHdlZW4gdHdvIHBvaW50cywgY3ViZSByb290cyBhbmQgaG93IHRvIGF2b2lkIHRoZSAjTlVNISBlcnJvci4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_SQRT(number)%2Cp_Ii9mdW5jdGlvbnMvc3FydCI%2Cs_FZnK44t52i4e4KW_.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **The SQRT function**

Returns the square root of a number. A negative number gives

=

SQRT(

## **Syntax**

```
SQRT(number)
```

<dl><dt>**number **</dt>
<dd>The number to take the square root of. It must be 0 or more.</dd></dl>

## **Examples**

B1=SQRT(144)

|  | A | B |
| --- | --- | --- |
| 1 |  | **12** |

D1=SQRT(B1^2+B2^2)

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Width | 3 |  | **5** |
| 2 | Height | 4 |  | |

B1=SQRT(ABS(-16))

|  | A | B |
| --- | --- | --- |
| 1 |  | **4** |

## **Questions**

<details>

<summary>

### Why does SQRT return

</summary>

The number is negative. If you only want the root of its size, write =SQRT(ABS(A2)).

</details>

<details>

<summary>

### How do I calculate a cube root in Excel?

</summary>

Raise the number to the power of 1/3, as in =A2^(1/3) or =POWER(A2,1/3). SQRT only does square roots.

</details>

<details>

<summary>

### Can I take a square root without SQRT?

</summary>

Yes. Raise the number to the power of one half, as in =A2^0.5 or =A2^(1/2). It gives the same result as =SQRT(A2).

</details>

<details>

<summary>

### How do I insert a square root symbol in Excel?

</summary>

Choose Insert, Symbol, and find the √ character. The symbol is only text, so for the calculation itself you still use SQRT or ^0.5.

</details>

## **Related functions**

- [**POWER**](https://excelsavvy.com/functions/power)
- [**ABS**](https://excelsavvy.com/functions/abs)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/functions/sqrt#webpage","description":"How to take a square root in Excel with SQRT or ^0.5: the distance between two points, cube roots and how to avoid the #NUM! error.","name":"Square root in Excel: how to use the SQRT function","url":"https://excelsavvy.com/functions/sqrt","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/sqrt#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/4"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/sqrt"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/sqrt#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"Square root in Excel: how to use the SQRT function","position":3}]},{"@id":"https://excelsavvy.com/functions/sqrt#article","description":"How to take a square root in Excel with SQRT or ^0.5: the distance between two points, cube roots and how to avoid the #NUM! error.","headline":"Square root in Excel: how to use the SQRT function","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U3F1YXJlIHJvb3QgaW4gRXhjZWw6IGhvdyB0byB1c2UgdGhlIFNRUlQgZnVuY3Rpb24%2Cdescription_~SG93IHRvIHRha2UgYSBzcXVhcmUgcm9vdCBpbiBFeGNlbCB3aXRoIFNRUlQgb3IgXjAuNTogdGhlIGRpc3RhbmNlIGJldHdlZW4gdHdvIHBvaW50cywgY3ViZSByb290cyBhbmQgaG93IHRvIGF2b2lkIHRoZSAjTlVNISBlcnJvci4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_SQRT(number)%2Cp_Ii9mdW5jdGlvbnMvc3FydCI%2Cs_FZnK44t52i4e4KW_.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/sqrt#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/sqrt#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Why does SQRT return","acceptedAnswer":{"@type":"Answer","text":"The number is negative. If you only want the root of its size, write =SQRT(ABS(A2))."}},{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I calculate a cube root in Excel?","acceptedAnswer":{"@type":"Answer","text":"Raise the number to the power of 1/3, as in =A2^(1/3) or =POWER(A2,1/3). SQRT only does square roots."}},{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Can I take a square root without SQRT?","acceptedAnswer":{"@type":"Answer","text":"Yes. Raise the number to the power of one half, as in =A2^0.5 or =A2^(1/2). It gives the same result as =SQRT(A2)."}},{"@id":"https://excelsavvy.com/functions/sqrt#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I insert a square root symbol in Excel?","acceptedAnswer":{"@type":"Answer","text":"Choose Insert, Symbol, and find the √ character. The symbol is only text, so for the calculation itself you still use SQRT or ^0.5."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U3F1YXJlIHJvb3QgaW4gRXhjZWw6IGhvdyB0byB1c2UgdGhlIFNRUlQgZnVuY3Rpb24%2Cdescription_~SG93IHRvIHRha2UgYSBzcXVhcmUgcm9vdCBpbiBFeGNlbCB3aXRoIFNRUlQgb3IgXjAuNTogdGhlIGRpc3RhbmNlIGJldHdlZW4gdHdvIHBvaW50cywgY3ViZSByb290cyBhbmQgaG93IHRvIGF2b2lkIHRoZSAjTlVNISBlcnJvci4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_SQRT(number)%2Cp_Ii9mdW5jdGlvbnMvc3FydCI%2Cs_FZnK44t52i4e4KW_.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U3F1YXJlIHJvb3QgaW4gRXhjZWw6IGhvdyB0byB1c2UgdGhlIFNRUlQgZnVuY3Rpb24%2Cdescription_~SG93IHRvIHRha2UgYSBzcXVhcmUgcm9vdCBpbiBFeGNlbCB3aXRoIFNRUlQgb3IgXjAuNTogdGhlIGRpc3RhbmNlIGJldHdlZW4gdHdvIHBvaW50cywgY3ViZSByb290cyBhbmQgaG93IHRvIGF2b2lkIHRoZSAjTlVNISBlcnJvci4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_SQRT(number)%2Cp_Ii9mdW5jdGlvbnMvc3FydCI%2Cs_FZnK44t52i4e4KW_.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
