怎么用函数让c1为数字时B1=A1，非数字为零或空值

起舞飞歌

求教各位大神，如何用函数实现当c列为数字时单元格B=A，为文字或者空值时b列显示为零或者空值。谢谢！

祝洪忠-

1. =COUNT(C1)*A1

复制代码

ringo777

=IFERROR(C3*1,0)

jerrike

1. =IF(N(C1),A1,"")

复制代码

niko88819

1. Sub nk()
   
2.     Dim ws As Worksheet
   
3.     Dim lastRow As Long
   
4.     Dim i As Long
   
5.     Set ws = ThisWorkbook.Sheets("Sheet1")
   
6.     lastRow = ws.Cells(ws.Rows.Count, "C").End(xlUp).Row
   
7.     For i = 1 To lastRow
   
8.         If IsNumeric(ws.Cells(i, "C").Value) Then
   
9.             ws.Cells(i, "B").Value = ws.Cells(i, "A").Value
   
10.         Else
    
11.             ws.Cells(i, "B").Value = ""
    
12.         End If
    
13.     Next i
    
14. End Su

复制代码

起舞飞歌

所有方法都 试了一下都完美解决，感谢各位