Tricky excel formula

[Pjam]

i am trying to write code that does the following.

i have a range of data from A1: A5000 once a cell is zero i want all cells below that to be zero as well. Any ideas?

 

[dmash]

Starting with cell b2.
=if(a2*b1=0,0,a2)

 

[scottylad2]

what will be going into the cell, a Formula? or are you likely to be inputting directly, if its the result of a formula the If already mentioned would need to incirporate that, ie IN A2 something like =IF(A1your formula=0,0,Your formula for A2) or similar. if your hardcoding numbers into the cells then you'll need a VBA solution

 

[Scott Huish]

Sub test()
Dim c As Range
For Each c In Range("A1:A5000")
    If c = 0 And c <> "" Then
        c.Resize(5001 - c.Row) = 0
        Exit For
    End If
Next
End Sub