Help with And/Or Clause in Formula

  • Thread starter Thread starter DoctorV
  • Start date Start date
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
 
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
 
Would advise that you use Frank's suggestion, since it's *not* an array
formula.
--


Regards,

RD
 
Back
Top