Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Get column name from index in Excel Table
  • How to Create Column Chart in Excel
  • How to Create Area Chart in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • Reverse List in Excel

References

  • How to use Excel FORMULATEXT function
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to get address of named range in Excel
  • How to use Excel MATCH Function
  • Count unique text values with criteria

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation specific characters only
  • Excel Data validation exists in list
  • Excel Data validation allow weekday only
  • Excel Data validation date in next 30 days

How To Calculate Square Root in Excel

by

The square root of a number is a value that, when multiplied by itself, gives the number. The SQRT function in Excel returns the square root of a number.

1. First, to square a number, multiply the number by itself. For example, 4 * 4 = 16 or 4^2 = 16.

Note: to insert a caret ^ symbol, press SHIFT + 6.

2. The square root of 16 is 4.

3. Instead of using the SQRT function, you could also use an exponent of 1/2. Don’t forget the parentheses.

4. If a number is negative, the SQRT function returns the #NUM! error.

5. You can use the ABS function to remove the minus sign (-) from a negative number.

Excel has no built-in function to calculate the nth root of a number. To calculate the nth root of a number, simply raise that number to the power of 1/n.

6. For example, 5 * 5 * 5 or 5^3 is 5 raised to the third power.

7. The cube root of 125 is 5.

8. For example, 2 * 2 * 2 * 2 * 2 * 2 or 2^6 is 2 raised to the sixth power.

9. The sixth root of 64 is 2.

Post navigation

Previous Post:

TRUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Pie Chart

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IF, AND, OR and NOT Functions Examples in Excel
  • How to use Excel TRUE Function
  • Excel If, Nested If, And/Or Criteria Examples
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • AND function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Calculate series of dates by workdays in Excel
  • Add workdays to date custom weekends in Excel
  • How to calculate next anniversary date or birthday in Excel
  • Get days between dates in Excel
  • Convert Excel time to decimal seconds

Grouping

  • How to randomly assign people to groups in Excel
  • Map inputs to arbitrary values in Excel
  • Map text to numbers in Excel
  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Spell Check in Excel
  • How to password protect excel sheet?
  • Subtotal by invoice number in Excel
  • 3D SUMIF for multiple worksheets in Excel
  • How to calculate percent sold in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning