在Excel中如何设置分条件及分段计算的公式答:=IF(AND(OR(E3="散居五保",E3="城镇三无"),K3-L3<=3000),MIN(K3-L3,3000),IF(AND(OR(E3="农村低保",E3="城镇低保"),(K3-L3)<=1000),(K3-L3)*0.5,IF(AND(OR(E3="农村低保",E3="城镇低保"),(K3-L3)<=2000),500+(K3-L3-1000)*0.3,IF(AND(OR(E3="农村低保",E3...
如何在excel中一个单元格设置三个公式?答:=IF(AND(A1="",A2=""),A3+A4,IF(AND(A1="",A3="",A4=""),A2,IF(A3="",A4=""),A1,"")))