Compounding problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am wanting to raise an indexation factor to the power n where 'n' is the no. of periods for which the factor has to be compounded. The power to which the factor has to be raised is a calulated figure relating to dates, and computes as a number, which is not necessarily an integer. The formula I use is as follows.

=(1+$O$2)^INT(AM7). This seems to work fine on its own, but I need to use it within a complex 'if' formula and when I try to paste it in I get an error message - 'The formula you typed contaoins an error. ...'

Anyone any experience of this or similar problems?

TIA
Ron
 
Please post the formula that doesn't work.

RonMcC said:
I am wanting to raise an indexation factor to the power n where 'n' is the
Click to expand...
no. of periods for which the factor has to be compounded. The power to
which the factor has to be raised is a calulated figure relating to dates,
and computes as a number, which is not necessarily an integer. The formula
I use is as follows.
=(1+$O$2)^INT(AM7). This seems to work fine on its own, but I need to use
Click to expand...
it within a complex 'if' formula and when I try to paste it in I get an
error message - 'The formula you typed contaoins an error. ...'
 
Back
Top