IFs

Hello,

It's easier to attach an excel spreadsheet here to explain this...

I cannot understand Formulas to compare the date and the way of calculations.

The formula uses for to calculate monthly amount. (i.e. the period : 15/04/2021-14/04/2022, £4660. So April amount is £4660/365daysx16days=£204.27, May amount is £4660/365daysx31days=£395.78....)

In the excel spreadsheet, the input data and the formulas are as following:

Period from 15/04/2021(C8), to 14/04/2022(D8), Total days: 365 (E8), Value £4660 (G8), Brought/Forward amount(i.e.£3676.93) (H8), Carry/Forward amount (i.e.£3281.15) (J8), Prepaid date [Formula:=IF((D8-$O$1 )<0,0, (D8-$O$1))](L8), Release amount [Formula:=IF(((J8-($G8*L8/$E8))*-1)<0, ROUND(((J8-($G8*L8/$E8))*-1), 2), "")](N8), the month end date(i.e.31/08/2021)(O1), Carry/Forward amount[Formula:=ROUND(SUM(J8:N8),2)] (i.e.£3111.37) (O8)

The first formula (L8) if() is comparing the dates, end date 14/04/2022 - the month end 31/08/2021, the future date is bigger than past date, so the answer is more than 0, however the formula uses "<0" I do not get it. but it shows "226" days, why?

The second formula(N8) shows "£-395.78" it needs to be in minus amount, therefore I do understand the "*-1" in the round formula, however I do not understand this part: (J8-($G8*L8/$E8))*-1)<0, why does it need "*-1"?

I will reuse the formulas for every months, however I do not understand them, I cannot change the cells in the formula.

Please could you explain these?

Thank you.