It would be impossible for this formula to ever evaluate to TRUE, since N20
would have to contain both "SM1-Assy" AND "SM2-Assy". A cell can only
contain one value.

Perhaps you want to use an OR condition for N20?

See if this is what you're looking for:

=IF(AND(K20:K632="450300",OR(N20:N632="SM1-Assy",N20:N632="SM2-Assy")),O20,)

HTH,
Elkar


"Craig Koon" wrote:

Can anyone please review and correct formula to work for me. Unable to get it
right. Too stumped to continue. Ready to pull last hairs out....

=IF(AND(K20:K632="450300",N20:N632="SM1-Assy",N20:N632="SM2-Assy"),O20,)



Thanks