Buzz
Excel's POWER function for exponentiation
Syntax: POWER (number, power)
Where:
- Number: obligatory. The base number. It can be any real number.
- Power: obligatory. The exponent you want to raise the base number to.
Calculate the exponentiation of a number.
- Chú ý
- Bạn cũng có thể dùng toán tử “^” thay cho hàm POWER để chỉ rõ cần nâng một số nào đó lên lũy thừa bậc mấy. Ví dụ như 6^2.
Given the following data table:
Compute the exponentiation of Power to the Number. Apply the Power function. The formula for cell C6 is: =POWER(A6, B6). The resulting value will be:
Copy the formula for the remaining cells. We get the final result:
This article introduces you to the Power function, which calculates the exponentiation of a number with a given base. This is one of the functions that Excel provides to perform simple and quick calculations. Additionally, you can refer to the LOGINV function in Excel to compute the standard logistic distribution function accumulation logarithm
