;1616503']Lynnette wrote:-

I am thinking there is an easier way- [....]-

=IF(H5="VEN-NUM",0,IF(H5="STARTUP",0,IF(E5=106547,0,

IF(E5=112565,0,IF(E5=133256,0,IF(BF5<1,0,(BH5-$AT5)*BF5))))))-

For what you have so far, you could write instead:

=IF(OR(H5={"VEN-NUM","STARTUP"},E5={106547,112565,133256},BF5<1),

0,(BH5-$AT5)*BF5)

Be careful to distinguish curly braces after H5= and E5= v. parenthesis

That might be difficult to see in some fonts. It is best t

copy-and-paste

the alternative above.

However....

Lynnette wrote:-

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-

You original expression does not implement that logic. Instead, your

original expression implements the following logic:

1. If H5 = "VEN-NUM" or "STARTUP", return 0

2. Else if E5 = 106547 or 112565 or 133256, return 0

3. Else if BF5<1, return 0

4. Else return (BH5-$AT5)*BF5 only if __all_3__ previous condition

fail.

I assume that is really what you want.

In contrast, your logic returns (BH5-$AT5)*BF5 if __any_1_of_3_

previous

conditions fails.

Lynnette wrote:-

IF "ES" or "TPG" which is only part of a part number

is in cell H then 0 otherwaise same formula.

[....] I do not know how to do step 3.-

Assuming I interpreted your intent correctly:

=IF(OR(H5={"VEN-NUM","STARTUP"},E5={106547,112565,133256},BF5<1),0,

IF(OR(ISNUMBER(SEARCH({"ES","TPG"},E5))),0,(BH5-$AT5)*BF5))

Technically, we could avoid the nested IF by including

ISNUMBER(SEARCH({"ES","TPG"},E5)) as another parameter of the first OR(

function.

But the nested IF is more efficient since the any of the othe

conditions

being true would preclude the need to do the searches