answersLogoWhite

0


Best Answer

You calculate square root in Excel using the Sqrt() function.

for example:

If the value of A1 is 81

and A2 contained the formula "=Sqrt(A1)",

The number 9 would be displayed.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

10y ago

You can multiply the number by itself or by the power of 2. In Excel, you have an operator to do it and also a function. To find the square of 34, you could do it in any of these ways:

=34*34

=34^2

=POWER(34,2)

You would normally use a cell reference instead of the actual value, so if the 34 was in cell A2 then the above formulas would become:

=A2*A2

=A2^2

=POWER(A2,2)

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

You can multiply a number by itself or multiply by the power of 2. That can be done with an operator or with a function. So there are several ways of doing it. Assuming the value was in cell A3, here are those 3 ways of doing it.

=A3*A3

=A3^2

=POWER(A3,2)

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Use the SQRT function.

Example:

=SQRT(A1)

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

=SQRT(number)

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate a square root of a number in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you calculate fourth root of any number?

1: Calculate the square root, then calculate its square root; OR 2: Take the logarithm of the number, divide it by 4 then take the antilog.


What to use square root in Excel?

To do square root in excel you type SQRT and then whatever number you want to square root in brackets. For instance, if you want the square root of 13 in one cell, you would type =SQRT(13).


What is 3 square root of 512?

Calculate the square root of 512 on any calculator, then multiply the result by 3.Note: If you actually mean the third root, this is NOT called the square root. You can calculate this in Excel with the formula: =512^(1/3) In other words, raise 512 to the power 1/3.


0.75 is the square root of what value?

Any positive number is the square root of its square. In other words, you need to calculate the square of 0.75.


What is the square root of negative 340?

That's the same as the square root of positive 340, times i. Many calculators can't calculate the square root of negative numbers, since they are not set up to calculate with complex numbers, but you can simply calculate the square root of the equivalent positive number, then add "i" to the result.


Is the square root of 12 a natural number?

No. A natural number is a whole number, that is, no digits after the decimal point. Calculate the square root of 12 on a calculator, and you will see that it is not a whole number.


Is 2934 a square?

Try it out! For example, you can use a calculator to calculate the number's square root. If you get a whole number - no decimals - then the number is a perfect square.


If you divide 4 by the square root of -7 and then times that by the square root of sin30 how many swag points will you gain?

I am not sure what you want to calculate; anyway, the square root of a negative number is a complex number: in this case, "i" multiplied by the square root of 7. The remaining calculations will also result in complex numbers. When you calculate points, you usually want a real number, not a complex number.


How do you calculate square roots as irrational numbers?

You can approximate a square root as a decimal or fraction. If you want the exact number, you have to leave it with the square root sign.


What is the key word for square root in abap?

sqrt is inbuilt function available in ABAP to calculate square root of any number.


How do you calculate the square root of minus one?

The square root of negative one is an imaginary number, signified by the italic lower-case i.


What is the approximate difference in tenths between the square root of 10 and the square root of 15?

The approx difference is 0.7