Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for - IF Formula
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") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for - IF Formula
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") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for - IF Formula
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|