formula

  • Thread starter Thread starter fdfsrs
  • Start date Start date
F

fdfsrs

I am creating a FV of money table;

F = (1+r/100)n

where n represents number of years; however n is an
exponent (ie. to the Nth power) How do I input an
exponent into an excel formula?

I have been struggling with this long hand for a long
time; this would be a much needed time saver

thanks
shannon
 
[email protected] said:
I am creating a FV of money table;

F = (1+r/100)n

where n represents number of years; however n is an
exponent (ie. to the Nth power) How do I input an
exponent into an excel formula?

I have been struggling with this long hand for a long
time; this would be a much needed time saver

thanks
shannon
Click to expand...

For example,
=A1^^n
where n is your number of years.
 
Back
Top