Combining "AND" with "OR" Statements
Thank you very much Hans
" wrote:
A B C D
1 yes 1 A =IF(B1=0;"";IF(A1="yes";"A";IF(A1="no";"R";"??")))
2 no 1 R =IF(B2=0;"";IF(A2="yes";"A";IF(A2="no";"R";"??")))
3 0 =IF(B3=0;"";IF(A3="yes";"A";IF(A3="no";"R";"??")))
4 Bla 1 ?? =IF(B4=0;"";IF(A4="yes";"A";IF(A4="no";"R";"??")))
if B can contain values other than 0 or 1 than use this form:
5 2 ##
=IF(B5=0;"";IF(B5<1;"##";IF(A5="yes";"A";IF(A5="n o";"R";"??"))))
Is that what you meant?
Hans
|