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!
