IF Statement that looks at different conditions

M

maddogg126

New Member
Joined
Sep 12, 2024
Messages
7
Office Version
  1. 365
Platform
  1. Windows
I am currently trying to get the number of days past due for outstanding invoices. My formula works for most but when it gets to invoices that are not due yet, it is giving me negative numbers when I am looking for a zero.

The formula is below. If the current due date (column J) is not past due, how do I have the formula return a zero value?

1726521904754.png
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
Add MAX to whichever calculation it is that is providing the negative result. IE:

MAX(0,K62-J62) or MAX(0,TODAY()-J62). Or both if they both should not show a negative result.
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

R
  • Solved
conditional format dates calculated using a formula
2
Replies
18
Views
313
rd_CEM
R
M
  • Question
Customer Ageing Different Formulas
Replies
3
Views
161
Alex Blakenburg
A
J
  • Question
Calculation based on value in table based on date range
Replies
0
Views
170
jsand
J
M
  • Question
Aging buckets By customer account aging report
Replies
2
Views
615
Alex Blakenburg
A
megera716
  • Solved
Return one of two dates depending on (numeric) day
Replies
3
Views
382
megera716
megera716

Forum statistics

Threads
1,221,531
Messages
6,160,355
Members
451,641
Latest member
loukyanarender

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top