Help to amend code

[ExcelFailure]

Hello,

The below code does the following:

Any cell with a 0 in the specified range gets #N/A put in the cell to the right of it.

How do I change it so:

Any cell with a 0 in the specified range gets #N/A put in the cell to the right of it UNLESS it has a value bigger than 0, in which case it gets a formula put in it?

Please Login or Register  to view this content.

[bradl822]

Try per below. Untested however.

Please Login or Register  to view this content.

[ExcelFailure]

Thank you, however I have noticed 1 thing that is different to what I first thought. The formula is different in each cell, because it's a formula to work out the cumulative amount. How can I do this please?

[bradl822]

Please Login or Register  to view this content.

[ExcelFailure]

Thank you...