Nesting IF Formula with multiple conditions

I’ve been piecing together formulas with information previously given to me on these wonderful forums, but can’t successfully get this one correct.

I need a formula that will determine if a line is active or expired by first looking at the category and then looking at the number of days. (While still incorporating the ISBLANK section of the current formula.)

For Example: If the category is either FWW or FWW Ext then the line will expire after 365 days. If not, then it will expire after 180 days.

I’ve attached a sample spreadsheet.
Book2.xlsx

Hoping this makes sense!

Thanks.

Is it possible to create a formula that does not reference a table? I should have explained better that the table was there merely for reference in this forum. The actual spreasheet has over 1,000 lines (and growing) and multiple tabs so as much as I can contain the data I want to.

Yes, I think that works. Let me play around with that on different lines. Thanks!

Originally Posted by etaf

does this do what you are after
=IF(ISBLANK(A2),"",IF( AND(OR(D2="FWW", D2="FWW Ext"), B2>365),"EXPIRED",IF(B2>180,"EXPIRED","ACTIVE")))

The formula above only works with the data remains static. If the category is changed then the status does not update even though the new data meets the criteria of the formula. The category data could change from time to time if a correction is needed.

Book2.xlsx

Originally Posted by etaf

sorry dont understand
if you are changing categories, then you would need a table approach - which you can change the criteria
otherwise if you want it fixed in the formula , then it cannot accommodate any changes to the rules

Ok I guess I don't understand this approach. If the formula is set to read certain criteria then it should still work when that criteria is met. No?

Hmm. That doesn't work either. Looks like I'm going to have to take a different approach.