Search code examples
excelexcel-formulalibreoffice-calc

MS-Excel Interest calculation using =IF

I want to calculate an interest on a fee, that is if a client has not paid full amount of fee before the 15th of the month an interest of 10% should added to the amount to be paid

my cells are Amount payable Column B Amount paid Column c upstanding amount Column D Date for payment Column E penalty to be Paid 10% Column

How do i calculate this ?

i tried the below formula and had Err:509 

=IF(E2=TODAY()>15, "Overdue" "B2*10/100",)

what i was trying to accomplish is .If today is on the 15th or the date is pass 15th of the month and there is upstanding amount to be paid attract a penalty of 10%

enter image description here

Solution

  • Things you could try 1) =if (e2>15, "overdue", b2*.10) or =if (text (now (),"dd") > 15, "overdue", b2*.1) You don't have a true and a false statement here (or rather the false statement is blank), also I don't know what you're trying to accomplish with e2=today ()>15 - if you're trying to get the day of the current month, you'll need e2=day (today ())>15