Excel IF AND functions

[bruce21]

Hello,

I have 3 conditions:

If a=no, b=no, c=yes then I want d to show ""
If a=no, b=no, c=no, then I want d to show "inop"
If a=no, b=no, c="", then I want d to show "inop"

If can write IF And statement for the first 2 conditions but I am having problems try to add the last condition to the formula. Any ideas?

[TABLE="width: 241"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD="align: left"]a[/TD]
[TD="align: left"]b[/TD]
[TD="align: left"]c[/TD]
[TD="align: left"]d[/TD]
[/TR]
[TR]
[TD="align: left"]no[/TD]
[TD="align: left"]no[/TD]
[TD="align: left"]yes[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]no[/TD]
[TD="align: left"]no[/TD]
[TD="align: left"]no[/TD]
[TD="align: left"]inop[/TD]
[/TR]
[TR]
[TD="align: left"]no[/TD]
[TD="align: left"]no[/TD]
[TD][/TD]
[TD="align: left"]inop[/TD]
[/TR]
</tbody>[/TABLE]

 

[dreid1011]

Perhaps something like this:

=IF(AND(A1="no",B1="no",C1="yes"),"",IF(OR(AND(A1="no",B1="no",C1=""),AND(A1="no",B1="no",C1="no")),"inop",""))

 

[bruce21]

Many Thanks!!

 

[dreid1011]

You're welcome.

 

[Albert 1]

Put in D1:

=IF(AND(A1="no",B1="no"),IF(OR(C1="no",C1=""),"inop",""))

 

[Joe4]

I have 3 conditions:

If a=no, b=no, c=yes then I want d to show ""
If a=no, b=no, c=no, then I want d to show "inop"
If a=no, b=no, c="", then I want d to show "inop"

If those really are the only three possibilities that you may have, you could use this simple formula:

=IF(C1="yes","","inop")

 

[jimrward]

Can C be anything other than yes no or empty, if not then the formula can be simplified further

 

[jimrward]

Ah joe you beat me to it

 

[Albert 1]

Nice, Joe4 !

 

[bruce21]

All great solutions. Thanks All!!