=IF(AND(ISNUMBER(FIND("氧氟沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:2μg/kg)","□ □未检出(定量限:3.0μg/kg)"),"error1")
=IF(AND(ISNUMBER(FIND("诺氟沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:3μg/kg)","□ □未检出(定量限:6μg/kg)"),"error1")
=IF(AND(ISNUMBER(FIND("培氟沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:3μg/kg)","□ □未检出(定量限:6μg/kg)"),"error1")
if函数可以循环嵌套多少层?我试了一下,四层就不行了
=IF(AND(ISNUMBER(FIND("沙拉沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:3μg/kg)","□ □未检出(定量限:6μg/kg)"),"error1")
=IF(AND(ISNUMBER(FIND("氧氟沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:2μg/kg)","□ □未检出(定量限:3.0μg/kg)"),"IF(AND(ISNUMBER(FIND("诺氟沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:3μg/kg)","□ □未检出(定量限:6μg/kg)"),"IF(AND(ISNUMBER(FIND("培氟沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:3μg/kg)","□ □未检出(定量限:6μg/kg)"),"IF(AND(ISNUMBER(FIND("沙拉沙星",C4)),ISNUMBER(FIND("21312",I4))),IF(ISNUMBER(FIND("蛋",B4)),"□ □未检出(定量限:3μg/kg)","□ □未检出(定量限:6μg/kg)"),"error1")")")")
|