|
最佳回答 |
0
|
free_zzLv6中级互助发布于2023-8-16 16:47
|
if(row()-2 < 3,20,if((row()-2)<=ROUND(B4*0.15,0),"20",if(and((row()-2)>ROUND(B4*0.15,0),(row()-2)<=ROUND(B4*0.45,0)),"15",if(and((row()-2)>ROUND(B4*0.45,0),(row()-2)<=ROUND(B4*0.95,0)),"10","5"))))
|
|
|
|
最佳回答 |
0
|
luojian0323Lv7资深互助发布于2023-8-16 16:47
|
|
|
|
|
最佳回答 |
0
|
用户k6280494Lv6资深互助发布于2023-8-16 16:47
|
if((row()-2)<3,20,if((row()-2)<=ROUND(B4*0.15,0),"20",if(and((row()-2)>ROUND(B4*0.15,0),(row()-2)<=ROUND(B4*0.45,0)),"15",if(and((row()-2)>ROUND(B4*0.45,0),(row()-2)<=ROUND(B4*0.95,0)),"10","5"))))
|
|
|
|
最佳回答 |
0
|
Z4u3z1Lv6专家互助发布于2023-8-16 16:47(编辑于 2023-8-16 17:05)
|
if(row()-2 < 1,"20",if(and(2<=row()-2,row()-2<=3),"15",if((row()-3)/(B4-1)<=0.15,"20",if(and((row()-3)/(B4-1)>0.15,(row()-3)/(B4-1)<=0.45),"15",if(and((row()-3)/(B4-1)>0.45,(row()-3)/(B4-1)<=0.95),"10","5")))))
|
|
|