excel怎么给空值打√
发布网友
发布时间：2022-10-28 04:26
共1个回答
热心网友
时间：2023-10-02 12:28
假如：A1-A5,有些有值，有些没有值，由B1-B5进行判断，可输入公式：=IF(A1<>0,"","√")、=IF(A2<>0,"","√")、=IF(A3<>0,"","√")、=IF(A4<>0,"","√")、=IF(A5<>0,"","√")…，以此类推。如图：
热心网友
时间：2023-10-02 12:28
假如：A1-A5,有些有值，有些没有值，由B1-B5进行判断，可输入公式：=IF(A1<>0,"","√")、=IF(A2<>0,"","√")、=IF(A3<>0,"","√")、=IF(A4<>0,"","√")、=IF(A5<>0,"","√")…，以此类推。如图：
