Refer to the below example image. The exponential function can be used to get the value of e by passing the number 1 as the argument. These let you run complex calculations with a few keypresses.
To use the POWER Excel Worksheet Function select a cell and type.
Create a Custom Column Add Column - Custom Column and use the custom function we created. Add Type SUM cellcell eg SUM A3B3 to add two cells values together or type kbdSUM cellcellcell eg SUM A2B2C2 to add a series of cell values together. POWER 52 2 get the result of number 45 raised to the power of 45 enter the following formula in Cell B2. In this article we will learn how to use the POWER function in Excel.