» 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:
- Monte Carlo Methods in Finance
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Business Plans Kit for Dummies (With CD-ROM)
- Business Analysis with Microsoft Excel (2nd Edition)
- Mastering Excel 2000 (for beginner)
- Microsoft Access 2002 for Dummies
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?
