How to correctly define If statements?

Hi,


I appear to have an issue with my code. It will populate the whole of my named range with '0's, when in reality I just want to populate those whose value in what I've named as "Table_Month" with a '0' when the value in "Table_Month" is greater than/equal to 10. I assume its just me wrongly defining the IF statement...

Also, I feel like I can make what I am trying to achieve much more efficient and quick. Does anyone have any suggestions? I can add further info if needs be...

Below is syntax:

Please Login or Register  to view this content.

Probably (untested)

Please Login or Register  to view this content.

Hi,

Thank you for your response. I want to populate the named range "Table_LM". Your code doesn't seem to reference it anywhere, I assume that would just populate the named range "Table_Month"?

Thanks.

Never mind - misunderstood your code (using a phone). Ignore it.

Hi,

Not a problem. Do you see a solution though?