Raising a number by a power: eg., squaring a number or cubing it

[kmc]

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)

 

[63falcondude]

=(1+.05)^5

or

=POWER(1+.05,5)

 

[JoeMo]

=(1+0.05)^5

 

[Norie]

Use ^, eg =(1+0.05)^5 (=1.276281563).

 

[kmc]

Sweet. Love simplicity. Worked perfectly.