The formulas looks up the value of text and DS96 and if not in the table E3:F2500, then it returns "NEW"

I want to add an and formula or another if statement to say that IF DS96 does not appear in E3:F2500 and if DU96 & DT96 is zero then the formula must return a blank. However if DU96 & DT 96 contain a value > than zero and DS96 does not appear in E3:F2500, then it must return "NEW".