Array Formula

[Ben S]

I have set up a table and ned to construct the following formula.

M3 = If I3 = "YES" & J3,K3,L3 = "No" If True put YES in M3 and if false put in NO in M3

 

[Andrew Poulsom]

Like this:

=IF(AND(I3="YES",J3="No",K3="No",L3="No"),"YES","NO")

 

[Mark W.]

{=IF(AND(I3="YES",J3:L3="NO"),"YES","NO")}

Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula. For more on array formulas see the Excel Help topic for "About array formulas and how to enter them".