Stumped on Excel Formula and Grateful for Help

[msvoboda27]

I have an excel file that I am trying to do a calculation only if value of 'Closed" isn't present in another cell. Closed is a status I'm using in a drop down.

Trying to calculate if "Met SLA" or 'Did Not Meet" only if status closed is not included,

I think I need to consolidate a Search and If statement,
Here's the two formulas that work in 2 different cells

=IF(ISNUMBER(SEARCH("Closed",M6,1)),"Exclude","Completed")
and this statement

=IF(W6<=72,"Met SLA"," Did Not Met")
Thank you for your time.

 

[jtakw]

You never mentioned anything about Column U before, and now I see you may have 0 also in W, try this:

Book1
	F
1	Exclude
Sheet60

Cell Formulas
Range	Formula
F1	=IF(OR(U6="",W6=0,W6="",NOT(ISNUMBER(SEARCH("Closed",M6)))),"Exclude",IF(W6<=72,"Met SLA","Did Not Met"))