如何在Excel中设定进度百分比自动显示?
发布网友
发布时间：2022-04-23 17:26
共5个回答
热心网友
时间：2023-10-10 21:53
方法：
1、打开EXCEL表格，选择单元格，点击”开始“--数字选项。
2、点击”常规“，在下拉列表中选择”百分比“即可。
热心网友
时间：2023-10-10 21:54
在E1中输入或复制粘贴此公式
=LOOKUP(COUNTBLANK(A1:D1),{0,1,2,3,4},{"100%","60%","30%","15%","还没开始"})
或
=LOOKUP(COUNTA(A1:D1),{0,1,2,3,4},{"还没开始","15%","30%","60%","100%"})
或
=LOOKUP(4-COUNTBLANK(A1:D1),{0,1,2,3,4},{"还没开始","15%","30%","60%","100%"})
下拉填充
在K1中输入或复制粘贴此公式
=LOOKUP(COUNTBLANK(A1,C1,E1,G1),{0,1,2,3,4},{"100%","60%","30%","15%","还没开始"})
或
=LOOKUP(COUNTA(A1,C1,E1,G1),{0,1,2,3,4},{"还没开始","15%","30%","60%","100%"})
或
=LOOKUP(4-COUNTBLANK(A1,C1,E1,G1),{0,1,2,3,4},{"还没开始","15%","30%","60%","100%"})
下拉填充
热心网友
时间：2023-10-10 21:54
E1=LOOKUP(COUNTA(A1:D1),{0,1,2,3,4},{"还没开始","15%","30%","60%","100%"})
下拉
进阶的可以用数据有效性
换成ACEG四列。进度列为K列
k1=LOOKUP(COUNTA(A1,c1,e1,g1),{0,1,2,3,4},{"还没开始","15%","30%","60%","100%"})
进阶用有效性的话，A列未填写可以，0不好实现
热心网友
时间：2023-10-10 21:55
在e2输入：
=TEXT(IF(COUNTIF(A2:D2,"<>"),IF(AND(COUNTIF(A2:D2,"<>")=1,A2<>""),15%,IF(AND(COUNTIF(A2:D2,"<>")=2,COUNTIF(A2:B2,"<>")=2),30%,IF(AND(COUNTIF(A2:D2,"<>")=3,COUNTIF(A2:C2,"<>")=3),60%,IF(COUNTIF(A2:D2,"<>")=4,100%,"非法操作")))),0),"0.00%")
然后下拉填充即可
===
刚才的公式有点问题，改好了。
热心网友
时间：2023-10-10 21:55
e2=iferror(lookup("座",A2:D2,{0.15,0.3,0.6,1}),0)
单元格改成%显示
如果要提示非法操作，得用数据有效性了
