...如果D3不等于D4到Dn且E3不等于E4到En,则在F3显示RIGHT,否则显示WRONG...答:D3不等于D4到Dn 是什么意思?如果D4到Dn中含有D3的值,且E4到En中含有E3的值,F3显示RIGHT:F3输入公式:=IF(COUNTIF(D4:D10,D3)*COUNTIF(E4:E10,E3),"RIGHT","WRONG")--- =IF(D3="","",IF(SUMPRODUCT((D4:D10=D3)*(E4:E10=E3)),"RIGHT","WRONG"))Dn=D3的同时E...