![]() ![]() So, if we are trying to find the value of 9 10 in excel, we can use the formula =POWER(9,10) Power – The exponent to raise the base number to. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |