Skip to content

Excel function · Math

Excel SQRT function

SQRT returns the square root of a number: the square root of 144 is 12. It is used to find the side of a square area, the distance between two points, or the average yearly rate from two years of growth.

In Turkish Excel: KAREKÖK

What it does

SQRT takes a single argument and returns the positive square root. A negative number has no real square root, so the result is #NUM!; if you need the root regardless of sign, make the number positive first with ABS.

For other roots use POWER or the ^ operator: a cube root is =A2^(1/3). A square root can also be written =A2^0.5; SQRT is simply easier to read. The average rate per period from two periods of growth is a root as well: =SQRT(Last/First)-1.

The straight-line distance between two points comes from Pythagoras: =SQRT((X2-X1)^2+(Y2-Y1)^2). In statistics, the standard deviation is the square root of the variance; STDEV.S calculates it directly.

Syntax

English Excel=SQRT(number)
Turkish Excel=KAREKÖK(sayı)

Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.

Arguments

ArgumentRequiredDescription
numberRequiredThe number, cell or formula whose square root you want. It cannot be negative.

Examples

1Find the side length of a square area

The areas of the square bays in the warehouse are known; the side length is the square root of the area.

C2fx=SQRT(B2)
Find the side length of a square area: example table
ABC
1BayArea (m²)Side (m)
2A16.004.00
3B20.254.50
4C30.005.48
5D50.007.07
  • C2 (filled down to C5)=SQRT(B2)

16 m² means a side of 4.00 m and 20.25 m² a side of 4.50 m; the 50 m² bay has sides of 7.07 m.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

2Straight-line distance from stores to the warehouse

The coordinates are in kilometres, and the warehouse is in G2:H2. The squares of the X and Y differences are added and the square root is taken.

D2fx=SQRT((B2-$G$2)^2+(C2-$H$2)^2)
Straight-line distance from stores to the warehouse: example table
ABCDEFGH
1StoreX (km)Y (km)Distance (km)Warehouse XWarehouse Y
2Central12810.042
3North62119.1
4Seafront25321.0
5Industrial420.0
  • D2 (filled down to D5)=SQRT((B2-$G$2)^2+(C2-$H$2)^2)

The central store is 10.0 km from the warehouse and the seafront store 21.0 km. The industrial store sits at the same point as the warehouse, so its result is 0.0.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

3Average yearly rate from two years of growth

The growth between 2023 and 2025 is spread over two years. Taking the square root of the total growth factor and subtracting 1 gives the average growth rate per year.

D2fx=SQRT(C2/B2)-1
Average yearly rate from two years of growth: example table
ABCD
1Product Group2023 Sales2025 SalesAverage Yearly Growth
2Cable480,000580,80010.0%
3Sockets210,000236,2506.1%
4Breakers150,000216,00020.0%
5Lighting320,000288,000-5.1%
  • D2 (filled down to D5)=SQRT(C2/B2)-1

For cable the average yearly growth is 10.0%; applied two years in a row, it leads to the 2025 figure. For breakers it is 20.0%. Lighting sales fell, so its rate is negative: -5.1%.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

Common errors and fixes

#NUM!

Cause: number is negative, for example the difference of two values came out below zero.

Fix: Check the expression; if the sign does not matter, use =SQRT(ABS(A2)).

#VALUE!

Cause: number is text that cannot be read as a number.

Fix: Make sure the cell really contains a number.

Good to know

  • Round the result when you use it as a measurement or quantity: =ROUND(SQRT(A2),2) for a side length, ROUNDUP for material you need to buy.
  • For a cube root use =A2^(1/3); keep the exponent in brackets, or Excel calculates A2^1 first.

In Nexell

Get Nexell to do it from a sentence

Type this in Nexell

Add a Distance column that calculates the straight-line distance from each store to the warehouse using the X and Y coordinates

Convert to table

Bring your store list into the tool and type this. Nexell adds the Distance column with real Excel formulas and shows it in the preview first; in the downloaded file, the distance changes when you edit the coordinates.

Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.

Free account · no card needed · 30 credits a month

Frequently asked questions

How do I calculate a cube root in Excel?

Use =A2^(1/3) or =POWER(A2,1/3). For 27 the result is 3. In general, the nth root is the power 1/n.

Is there a difference between SQRT and ^0.5?

The result is the same, and both return #NUM! for negative numbers. SQRT is just clearer to whoever reads the formula.

Related functions

All math functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free