excel函数问题，请指教

来源：百度知道编辑：UC知道时间：2024/06/01 03:06:50

Excel中如果b1为性别，c1为年龄，我要在d1里算出符合以下条件：如果性别是男，并且年龄大于49则输出“是”，否则输出否，如果性别是女，并且年龄大于39，则输出“是”，否则输出“否”。谢谢高手

=IF(OR(AND(B1="男",C1>49),AND(B1="女",C1>39)),"是","否")

=if(b1="男",if(c1>49,"是","否"），if(b1="女",if(c1>39,","是","否")))

=if(or（and（b1="男",C1>49),and（b1="女",C1>39)）,"是","否")

=IF(AND(B1="女",C1>39),"是",IF(AND(B1="男",C1>49),"是","否"))
这个对的了,拿分来

=IF(AND(B1="女",C1>39),"是",IF(AND(B1="男",C1>49),"是",""))

用IF