IF Statements

angusn

New Member
Joined
Jan 20, 2011
Messages
27
Office Version
  1. 365
Platform
  1. Windows
I'm missing something but can't see for the lack of coffee.

B6 - 21-Feb-18 (Due Date)
L1 - =today()
E9 - 20-Jan-18 (Start Date)
F9 - Currently Empty (Completed Date)
G9 - =IF(A9="","",IF(F9="",$B$6-$L$1,"Done")) (Days remaining till past due/days past due)
H9 - =IF(E9="","",IF(ISBLANK(F9),"In Progress",IF(G9<=0,"Past Due","Complete"))) (Problem Child)

I'm trying to get H9 to show "Past Due".

When I have a date in E9 and F9 is blank and the task is not past due (G9 is a positive number), Cell H9 shows In Progress. Great.

When I have a date in E9 and a date in F9, Cell H9 shows Complete. Great.

When I have a date in E9 and F9 is blank and the task is past due (G9 is a negative number, Cell H9 Does Not show Past Due. This is what I can't get to work.

Thanks in advance.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Hi angusn;

Your formula looks fine, I believe the issue is the way you've built it. G9 populates a number if F9 is empty and your formula in H9 populates "In Progress" as far as F9 is empty.

Try =IF(E9="","",IF(G9<0,"Past Due",IF(F9<>"","Done","In Progress")))
 
Upvote 0
jtakw - A9 is for the name of the task needed to be done. Just hard typed as needed.


taccoo73 - That's working. So I needed to get the Past Due in before adding the empty F9 cell trigger into the mix. I get that. Thanks.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

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