Option Explicit
Sub Formule()
Range("b2:b" & Cells(Rows.Count, 1).End(xlUp).Row).FormulaR1C1 = "=IF(RC[-1]=0,"""",FALSE )"
End Sub
Sub Macro1()
Columns("A:A").NumberFormat = "0.00"
Range("B2:B" & Range("A65536").End(xlUp).Row).Formula = "=IF(RC[-1]=0,"""" )"
Cells(1, 1).Select
End Sub
Sub FormuleTer()
Dim a As Range
Set a = Range("A2", Cells(Rows.Count, "A").End(xlUp))
a.Offset(, 1) = Evaluate("=IF(" & a.Address & "=0,"""",FALSE)")
End Sub