if function formula on overdue date

[erlindafb]

HI,

I got a worksheet of my receivable file, updating it monthly for management reporting, the formula should be

That if due date it will fall on the number of days it was overdue, but whenever it fall exactly on the date like zero days overdue, the amount is overdue but it falls the column of not yet overdue.

Please help me to correct the formula. I knew I'm missing something on the formula

thanks in advance : ) hava nice day!!!

 

[etaf]

do you need just a <=
IF ( B5 < = $L$1, ......
if just less than - if the dates are the same , then its NOT less then , so will be zero

 

[erlindafb]

do you need just a <=
IF ( B5 < = $L$1, ......
if just less than - if the dates are the same , then its NOT less then , so will be zero

tried adding that but it did not work though...

 

[etaf]

you would need to add the spreadsheet - WITHOUT sensitive data , on a share like onedrive or dropbox
OR use XL2BB - see the menu bar or my signature and post here

Its difficult to see from the image

 

[FuNeS13]

just drop the = sign on your second if...

=IF(B5<$L$1,  (IF(($L$1-B5)>K5, I5, 0)),0)

 

[erlindafb]

just drop the = sign on your second if...

=IF(B5<$L$1,  (IF(($L$1-B5)>K5, I5, 0)),0)

thank you!!!
it works!!!!