ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel problem (https://www.excelbanter.com/excel-worksheet-functions/18700-excel-problem.html)

Nilzmeister

Excel problem
 
How do I find the square root of something in excel? I can't find it ou?t

Kassie

=SQRT(value)

"Nilzmeister" wrote:

How do I find the square root of something in excel? I can't find it ou?t


Bob Phillips

or if you remember your maths

=A1^(1/2)

which extends into

=A1^(1/3) etc

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kassie" wrote in message
...
=SQRT(value)

"Nilzmeister" wrote:

How do I find the square root of something in excel? I can't find it

ou?t



Bernard Liengme

And just to complete the pictu
=POWER(A1,1/2)
But SQRT is better from a documentation point of view - most people would
guess what it means!

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kassie" wrote in message
...
=SQRT(value)

"Nilzmeister" wrote:

How do I find the square root of something in excel? I can't find it ou?t





All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com