第1个回答 2011-04-20
=IF(A1>20,IF(A2="工程师","是"),"否")本回答被提问者采纳
第2个回答 2011-04-20
=if(and(A1>20,A2="工程师"),"是","否")
绝对准确!
第3个回答 2011-04-20
=if(and(A1>20,A2="工程师"),"是","否")
第4个回答 2011-04-20
=if((A1>20)*(A2="工程师"),"是","否")
第5个回答 2011-04-20
=if((A1>20)*(A2="工程师"),"是","否")