Without using Excel's financial functions where this is already programmed, how do I write a formula to say take a number to the fifth power. For instance, in solving for the present value of a number, the formula is: PV=FV(1+i)n, where n is the power of a number.
So how do I tell Excel to do (1+.05) to the fifth power without having to type: (1+.05)*(1+.05)*(1+.05)*(1+.05)*(1+.05)
So how do I tell Excel to do (1+.05) to the fifth power without having to type: (1+.05)*(1+.05)*(1+.05)*(1+.05)*(1+.05)