Mulitple Conditionals without lookup table?

  • Thread starter Thread starter Donald Roberts
  • Start date Start date
D

Donald Roberts

Greetings and many thanks for your input,

I am trying for a single formula without a lookup table for the following
type of calculation?
IF (X = frequency, PMT (FV),0)

Example Inputs : Frequency (every 5 years) , Begin Date (2004) , End date
(2024)
Active = 2004, 2009, 2014, 2019, 2024

Donnie
 
One way:

A1: rate (annual)
A2: Begin Date
A3: End Date
A4: Payment Frequency
A5: Initial Amount
A6: Future Value

then

=IF(A4<>0,PMT(IF(A4<1,A1*A4,A1),(A3-A2)/A4,A5,A6,1),0)

I'm not sure what your "Active = " refers to, specifically - the above
formula will calculate the payment for the frequency entered, so if hte
frequency was 5, the payments would presumably be due 2004, 2009, etc.
(if the first payment wouldn't be due until 2009, change the 1 after A6
to 0).
 
Back
Top