I am trying to build a formula based on the following information.
IF cell E = (a list of specific numbers) then true would be 0 and false would be (BH-AT)*AF. I also would like the formula to do a secondary IF statement that if "VEN-NUM" or "STARTUP" is in Cell H then 0 otherwise the same formula and finally IF "ES" or "TPG" which is only part of a part number is in cell H then 0 otherwaise same formula.
Here is what I have thus far. I am thinking there is an easier way and I do not know how to do step 3.

=IF(H5="VEN-NUM",0,IF(H5="STARTUP",0,IF(E5=106547,0,IF(E5=1125 65,0,IF(E5=133256,0,IF(BF5<1,0,(BH5-$AT5)*BF5))))))

1. IF E5 = 106547 or 112565 or 133256 then 0... If False then (BH5-AT5)*BF5
2. IF H5 = "VEN-NUM" or "STARTUP" then 0... If False then (BH5-AT5)*BF5
3. IF H5 contains "ES" or "TPG" then 0... If False then (BH5-AT5)*BF5

Thanks
Lynnette