Hi Lynette,

Am Mon, 3 Mar 2014 15:22:43 +0000 schrieb ljochmann:

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

I don't really understand your question :-(
If E56 is False then always (BH5-AT5)*BF5?
Or then testing H5 and only if both are False then (BH5-AT5)*BF5?

If E5 AND H5 must be false for (BH5-AT5)*BF5
try:
=IF(OR(E5={106547;112565;133256}),0,IF(OR(H5={"VEN-NUM";"STARTUP";"ES";"TPG"}),0,(BH5-AT5)*BF5))
Else try:
=MAX(IF(OR(E5={106547;112565;133256}),0,(BH5-AT5)*BF5),IF(OR(H5={"VEN-NUM";"STARTUP";"ES";"TPG"}),0,(BH5-AT5)*BF5))
if the results always are positive


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

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. I hope that makes more sense for you.
Thanks for helping.
Lynnette

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

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


Thank you for your help.
Lynnette