Inserting a formula into multiple cells

I have a spreadsheet where I want to insert a formula into H2 and below if the cell in the corresponding row in column F is greater than "0".

I know that somehow I need to use something like the code below but have no idea how to make it dynamic in the way that you can copy formulas down or figure out how to 'ask' if the corresponding row in column F is greater than "0"

Please Login or Register  to view this content.

Can anyone help or know where I can find a similar example?

Thanks Dave, it works great. I would have not been able to figure that out for some time!!