» 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
Getting a root of a number is the same as raising that number to the power of 1/root.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:
- Microsoft Access 2002 for Dummies
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Retire Young, Retire Rich
- Microsoft Excel VBA Programming for the Absolute Beginner
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
No comments have been submitted.
