In cases of loans and investments with a variable interest rate, AMORLINC may not prove to be useful. Functions like XIRR are useful in such cases. When data is not currency related, you cannot use the AMORLINC formula. In such cases, you may use the DATEDIF or CONVERT formula before using AMORLINC.