Originally Posted by Claus Busch

Hi Lynette,

Am Mon, 3 Mar 2014 17:43:48 +0000 schrieb ljochmann:

If any of the statements are FALSE then do (BH5-AT5)*BF5. Does not need
to be a combination of one or the other, just is any are false then I
would like the formuala to happen.

then try:
=IF(OR(E5={106547;112565;133256},COUNT(SEARCH({"VE N-NUM";"STARTUP";"ES";"TPG"},H5)),BF5<1),0,(BH5-AT5)*BF5)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2