excel计算得分超过100%怎么算?答:你的公式可简化为:=SUM(MIN(G5,1)*40,N(OFFSET(J5,,{0,3,6,9}))*15)如果J、M、P、S列也存在可能超过100%的情况,就用:=SUM(MIN(G5,1)*40,(SUBTOTAL(5,OFFSET(J5,,{0,3,6,9}))*(SUBTOTAL(5,OFFSET(J5,,{0,3,6,9}))<1)+(SUBTOTAL(5,OFFSET(J5,,{0,3,6,9})...
EXCEL多级if加封顶,这么要怎么写答:公式为:=IF(A2>100,MIN(A2-100,5)*0.5,IF(AND(A2<100,A2>100-10),(A2-100)*(0.5),IF(A2<=(100-10),(MIN(10,100-A2)*(-0.5))+(A2-100)*0.5,"基准金额"))),下拉填充公式就好了!如有疑问可以继续讨论!
求大神excel函数,95以上得100分90-94个,得90分85-89个得80分。扣完...答:用ifs函数实现,公式如下:=IFS(A1>=95,100,A1>=90,90,A1>=85,80,A1>=80,70,A1<80,0)具体操作演示: