Roots in Formulas

[Miguel Goizueta]

How can I introduce "any Number Root" in a formula?

 

[PTT, Inc.]

By using the ^ (caret) symbol. For example, 10 "cubed" is 10^3.

Bill Foley
www.pttinc.com

 

[Norman Harker]

Hi Miguel!

Excel uses the ^ (it's above the 6) for raising to powers.

So 3^3 is 3 raised to the power of 3
and
27^1/3 is the cube root of 27

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bernard Liengme]

The use of the carat operator (5^2) is common. However, Excel also has the
POWER function.

 

[Harlan Grove]

The use of the carat operator (5^2) is common. However, Excel also has the
POWER function.

....

And like all functions that do nothing more than duplicate what operators do
(SUM for + and PRODUCT for * with 3 or fewer operands, & with any number of
operands), they should be avoided at all times because they slow down
recalculation, take up more storage, and waste a level of function call
nesting while providing no benefits.