Hi,

I need to create the formula to get the result as "Yes" or "No" in Cell D1

If the name in (A1 is "Deepak" and the name in B1 is "Deepak" and the name
in C1 is "Good" or "Fair", then in D1 it should show "Yes" else "No")

Try this in D1

=IF(AND(A1="Deepak",B1="Deepak",OR(C1="Good",C1="F air")),"Yes","No")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Deepak Sharma" wrote:

Hi,

I need to create the formula to get the result as "Yes" or "No" in Cell D1

If the name in (A1 is "Deepak" and the name in B1 is "Deepak" and the name
in C1 is "Good" or "Fair", then in D1 it should show "Yes" else "No")

hi,
try this....

=IF(AND(A1="Deepak",B1="Deepak",OR(C1="good",C1="f air")),"yes","no")

adjust cell references to fit your data.

regards
FSt1

"Deepak Sharma" wrote:

Hi,

I need to create the formula to get the result as "Yes" or "No" in Cell D1

If the name in (A1 is "Deepak" and the name in B1 is "Deepak" and the name
in C1 is "Good" or "Fair", then in D1 it should show "Yes" else "No")