# if function formula on overdue date

#### erlindafb

##### New Member
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.

thanks in advance : ) hava nice day!!!

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### etaf

##### Well-known Member
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

##### New Member
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

##### Well-known Member
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

##### Board Regular
just drop the = sign on your second if...
Excel Formula:
``=IF(B5<\$L\$1,  (IF((\$L\$1-B5)>K5, I5, 0)),0)``

#### erlindafb

##### New Member
just drop the = sign on your second if...
Excel Formula:
``=IF(B5<\$L\$1,  (IF((\$L\$1-B5)>K5, I5, 0)),0)``
thank you!!!
it works!!!!

Replies
7
Views
666
Replies
1
Views
304
Replies
5
Views
838
Replies
3
Views
377
Replies
3
Views
442

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,119
Messages
5,768,221
Members
425,460
Latest member
Astros1243

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back