Conditional Formulas

C

Craig Koon

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
 
M

Michael M

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
 
B

Bob Phillips

=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)
 
E

Elkar

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
 
Top