0
I am creating a payments spreadsheet to accurately calculate interest on overdue payments.
My formula used in the 2003 version that I am trying to copy into an updated version is:
=zInterest(RateTable,MAX($D15,$K$16),$H$13,1,0)*$G15*O15
- D15 is the start date;
- K16 is the earliest date in the rate table;
- H13 is the payment date;
- G15 is the payment amount;
- and O15 is the compound interest rate.
The error I am getting is a #NAME error. I believe this is purely due to =zinterest
no longer being a formula in 2010 excel, however I cannot work out which new formula to use.
The payments are made weekly, and for 180 weeks.
I would really appreciate any help I get!
4It might be a UDF, Zinterest might be a user defined function look in your old sheet for modules – Sam – 2017-07-24T06:20:06.760
Write this up as an answer so that others who had similar problems will find the answer clearly marked and indicated as such. – music2myear – 2017-08-02T22:48:41.637