M
Miguel Goizueta
How can I introduce "any Number Root" in a formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PTT, Inc.
N
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.
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.
B
Bernard Liengme
The use of the carat operator (5^2) is common. However, Excel also has the
POWER function.
POWER function.
H
Harlan Grove
....Bernard Liengme said: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.