Help with And/Or Clause in Formula

[DoctorV]

I have a formula that I want to do the following
If cell B40 ="New" and any value in cells c40:c44 = "CAP" I want t
return the value "CAP" otherwise if false return the value "N/A"

How can I do tha

 

[RagDyer]

Try this array formula:

=IF(AND(B40="New",OR(C40:C44="Cap")),"Cap","N/A")

Must be entered with CSE (<Ctrl> <Shift> <Enter>).
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a formula that I want to do the following
If cell B40 ="New" and any value in cells c40:c44 = "CAP" I want to
return the value "CAP" otherwise if false return the value "N/A"

How can I do that

 

[Frank Kabel]

Hi
try
=IF(AND(B40="New",COUNTIF(C40:C44,"CAP")>0),"CAP","N/A")

 

[DoctorV]

Thanks to both of you it works great I really appreciate it!!!

 

[RagDyer]

Would advise that you use Frank's suggestion, since it's *not* an array
formula.
--


Regards,

RD