Hi, i need help on a formula.
We have paid 15 days of interest upfront, hence the input in AT40 and AU40.
For 1st term interest, it is calculated at day 16 to day 90. AV40 should only start at day 16 and cap at 75 as 90 days minus 15 days is 75 days. Please help me with formula in AV40.
We have paid 15 days of interest upfront, hence the input in AT40 and AU40.
For 1st term interest, it is calculated at day 16 to day 90. AV40 should only start at day 16 and cap at 75 as 90 days minus 15 days is 75 days. Please help me with formula in AV40.