Excel Calculation (IF/AND/OR)

[Shankar Raman]

Need a Solution for a Conditions listed in the attachment either by IF/AND/OR or any logical calculations. I have a multiple conditions with Yes or No . I can enter only Yes or NO but the answer should vary accordingly.

For Example , for each condition of a,b,c in Yes/No Format, Each color should be the answer.

a Yes Yes No Yes
b NO yes No Yes
c yes Yes No No

Red Blue White Black

Shankar

 

[Ronak Parekh]

Is this you are looking for?

=IF(COUNTIF(D5:D11,"Yes")=COUNTA(C5:C11),"Red","Blue")
=IF(COUNTIF(E5:E11,"Yes")=COUNTA(E5:E11),"White","Black")

 

[Khalid NGO]

Hi Shankar and welcome the forum Chandoo.org.

Can you be more specific about your requirement?
Please mention the expected result manually.

and i didn't understood what you've done with DV in range D5:D11

Regards,