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?
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
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?
a | b | c | d |
no | no | yes | |
no | no | no | inop |
no | no | inop |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>