=IF(D7=0,"",RecipeInput!G11) I have used the if function to enter a value in D1 (in the image) I need A1 to enter "0" when D1 is populated. Can someone help please Thanks in advance