How to Use SQRT() in Google Sheets

Description

Returns the positive square root of a positive number.

How To Actually Use SQRT() in Sheets

SQRT(value)

Free 2027 printable calendar in Google Sheets The whole year on one page. Copy it to your Drive, plan the big dates, and print it as a PDF. Get the free calendar

Try SQRT yourself

In cells B1:B10, enter positive numbers. In cells C1:C10, use the SQRT formula to calculate the square root of the corresponding values in column B.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for SQRT(). Click through to watch.

Watch more tutorials

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! ...

Beginner

COUNTA() INDEX() RAND() ROUND()

Unlock these tutorials

Learn more about the SQRT() formula:

Generate a SQRT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses SQRT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a SQRT() formula

Ads keep the free stuff free. Members browse ad-free — log in or see pricing.

How to Use SQRT() in Google Sheets

Try SQRT yourself

More related tutorials

Calculate ROAS in Google Sheets

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)