» Square root and cube root in Microsoft Excel
VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
Example:
The square root of x is x^(1/2). The square root of A1 is: =A1^(1/2).
You can also use the built-in worksheet function SQRT: =SQRT(A1)
The cube root of x is x^(1/3). The cube root of A1 is: =A1^(1/3).
You can also use the built-in worksheet function POWER: =POWER(A1;1/3)
Book Store:
thanks for the tip
stefan
yes i needed to know this when trying to draw a graph for a yr 12 physics prac. just clicked 'feeling lucky' on a google search, got this. helped me straight away
samle work example
johnson john
pls can you help me out wth some already work questions on how to use ms excel in working accounting problems and statistics like mean, mean deviation ,variance etc
Excel square root and standard deviation
Em
Is there any way that you can have just one formula for standard deviation? e.g. the first sum to find the total of the numbers squared devided by the number of units
=SUM(1*B6+4*C6+9*D6+16*E6+25*F6+36*G6)/H6-1
Call this A2
then the 2nd sum to find the square root e.g =SQRT(A2)
is there anyway of combining the 2?
