EXCEL如何在一单元格填写任何字符,另一单元格就出现固定某一字符

2025-02-23 06:27:50
推荐回答(2个)
回答1:

C1=IF(AI<>"","√ ","")下拉填充即可!

回答2:

=if(a1<>"","√ ","")