Conditional Formulas
 

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

Conditional Formulas
 

Hi Craig
You haven't allowed for a FALSE condition
Try this:
=IF(AND(K20:K632="450300",N20:N632="SM1-Assy",N20:N632="SM2-Assy"),O20,"nothing")

and use Ctrl Shift Enter to make it an array

HTH
Michael M

"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

Conditional Formulas
 

=SUMPRODUCT(--(K20:K632="450300"),--(N20:N632={"SM1-Assy","SM2-Assy"}),O20:O
632)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Craig Koon" <Craig wrote in message
...
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

Conditional Formulas
 

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