表格中指定一个单元格中包含A就显示a包含B就显示b包含A和B 就显示ab答:见截图 B1输入 =IF(SUM(N(ISNUMBER(FIND({"A","B"},A1)))=2,"ab",IF(ISNUMBER(FIND("A",A1)),"a",IF(ISNUMBER(FIND("B",A1)),"b","")))公式下拉
EXCEL中根据A单元格输出结果输出B单元格结果答:MONTH(A1)-MONTH(NOW())>=1),YEAR(NOW())-YEAR(A1)-1,YEAR(NOW())-YEAR(A1))哦 ! 只能算出多少年!忘了后面的还有呢!就在C1加个IF来实现年限系数吧!~=IF(B1<=2,0.8,IF(B1<=4,0.9,IF(B1<=6,1,IF(B1<=8,1.1,IF(B1<=10,1.2,IF(B1>10,1.3,"")))...