» 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:
Recommended Books:
- Excel 2002 For Dummies®
- The Interpretation of Financial Statements
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Microsoft Office XP Introductory Concepts and Techniques
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
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?
