Repeat Formula until it Returns zero [VBA]

[acerlaptop]

Hi. Is there a way to paste certain formula in column E until the formula returns a zero value? Column E don't have anything in it. So basically, I want to input a formula in E1, then input same formula in E2... and so forth.. until the formula return a zero value.

 

[alansidman]

Please supply an example of what you have and then what you want to have. Cannot visualize your issue.

 

[OceanStateSixSpeed]

I'm not exactly sure what you're trying to do, but maybe the "Goal Seek" function is what you're looking for.