Hello friends! It’s me again. Today, to continue the basic Excel series for beginners, I will introduce Square Root, also known as square root in Excel.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Exponents in Excel
Step 1: Mark the = sign to let Excel recognize it as a calculation.
Step 2: Record the calculation. (If you want to record the caret, you can use the key combination SHIFT + 6)
Square Root in Excel
Since we can’t use the regular keyboard to write square root notation, Excel has converted it to a function we can use: =SQRT()
Example using the SQRT . function
Or we can use 1/2 exponent instead of using the SQRT . function
For the square root of a negative number, the result will return an error (In mathematics, the condition for the square root to have a solution is that the number inside must be greater than or equal to zero)
We can use the ABS function to make negative values according to the following example
Cube root
Since in Excel we don’t have a function for square roots, we will use exponents with 1/3 Please
Here is an example of a square root
So I just guided you about square root in Excel. How do you feel? Leave a comment to let me know what you guys think!
