Help with And/Or Clause in Formula

D

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
 
R

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
 
R

RagDyer

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


Regards,

RD
 
Top