ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Square root and cube root

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)

 

Document last updated 2000-02-04 12:45:07      Printerfriendly version

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address