I have an IF statement but How do I exclude values.

[mparker123]

I wrote an IF statement for filtering past due items. =If([Due Date]<Today(),[Due Date]). Within this expression I want it to filter out anything that is( Status --  Not Required, Done) and filter for only (sub-tasks). How would I write an expression for this?

[tajmohamed30 · Accepted solution]

How to use the IF statement to exclude some un-wanted data in a field?