Multiply by compounding periods - ANS-RATE
Divide by compounding periods - ANS-NPER
Type 0 - ANS-Payments are made at the end of the period
Type 1 - ANS-Payments are made at the beginning of the period
Finds exact match or next lower in your table array - ANS-Range Lookup Type True
Finds exact match in your table array - ANS-Range Lookup Type False