怎么设置excel公式
(如条件1:A1>0,同时满足a2=0,a3=0,数值为500,条件2:A1=0,同时满足A2>0,A3=0,数值为300,条件3:A1=0,同时满足A2=0,A3>0,数值为100,条件4:A1>0、同时满足A2>0,A3>0,数值为0),条件不成立数值为0.
=IF(AND(A1>0,A2=0,A3=0),500,IF(AND(A1=0,A2>0,A3=0),300,IF(AND(A1=0,A2=0,A3>0),100,0)))
=IF(A1=0,IF(AND(A2=0,A3>0),100,IF(AND(A2>0,A3=0),300,0)),IF(A1>0,IF(AND(A2=0,A3=0),500,0),0))
就是IF函数家and和or
热门标签: