ykciV
满足这4个条件的函数怎么写啊有大神会的吗ykciV
=IF(OR((AND(A>=3,B=0),C<=10),"3"),IF(AND(A&get;0,B&get;0,C<=0.5 A),"2")，IF（B&get;0.5 A,"1"）,IF(OR( A=0,C=0),"延期“）
头木西
0.5a是数学公式写法，不是excel公式写法ykciV
=IF(OR((AND(A>=3,B=0),C<=10),"3"),IF(AND(A&get;0,B&get;0,C<=0.5 *A),"2"),IF（B&get;0.5* A,"1"）,IF(OR( A=0,C=0),"延期“）
ykciV
. 手机操作函数好麻烦
ykciV
=IF(OR((AND(A>=3,B=0),C<=10),"3"),IF(AND(A&get;0,B&get;0,C<=0.5 *B),"2"),IF（B&get;0.5 *A,"1"）,IF(OR( A=0,C=0),"延期“）
