![]() Number – The base number to raise to a power/exponent. Here we’ll show you how to apply the calculation using both functions than the ^ trap for the unwary. For negative bases and fractions, Power() is the safer and accurate choice. A lot of people use ^ all the time and ignore the full function but that can be a mistake.įor positive (above zero) integers both Power() and ^ work fine. ![]() Power () function or the ^ character shortcut. So, 10 2 would be the same as 10 x 10.Įxcel has two exponent functions. ![]() Assuming n is a positive integer, exponentiation refers to repeated multiplication of the base a, n times. We’ll explain why the Power() and ^ don’t always give the same or even correct result.Įxponentiation is an operation in mathematics, written as a n, involving the base a and an exponent n. Like many things in Excel, what looks simple has some traps for the unwary. There are two exponential function options in Excel.
0 Comments
Leave a Reply. |