Excel中,A1大于0,且B1等于1时,C1等于100;A1大于0,且B1等于0时,C1等于...答:参看下图,在C1单元格中输入公式:=IF(AND(A1>=0,B1=1),100,IF(AND(A1>=0,B1=0),80,IF(AND(A1<=0,B1=1),70,IF(AND(A1<=0,B1=0),60)))若有帮助请采纳!!!
关于Excel,如果A1为A,则B1为1,如果A1为B、C、D,则B1为0,函数怎么写答:在B1中写函数 =if(a1="A","1",if(OR(a1="B",a1="c",a1="D"),"0",""))
在excel中当a1单元格大于0,b1单元格等于0时则e1等于a1*b1*d1*c1,当...答:在E1中输入或复制粘贴下列公式 =IF(AND(A1>0,B1=0),A1**B1*C1*D1),IF(AND(A1=0,B1=0),A1*B1,IF(AND(A1>0,B1>0),A1*B1*C1),"")))或 =IF(AND(A1>0,B1=0),PRODUCT(A1:D1),IF(AND(A1=0,B1=0),A1*B1,IF(AND(A1>0,B1>0),PRODUCT(A1:C1),"")))下拉填充 ...