VBA - Insert a IF function within an exiting coding.

Thank you very much Nathansav! It worked my range is unknow (it can go anywhere between 150,000 rows 500,000 or more).
So how would you enter that in the coding?