when cells value is entered change another cell to "0"

GregT

New member
Joined
Nov 3, 2019
Messages
11
Reaction score
0
Points
1
Excel Version(s)
2016
Screenshot (37).jpg
=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
 

Attachments

  • Screenshot (37).png
    Screenshot (37).png
    6.4 KB · Views: 13
Back
Top