Results 1 to 1 of 1

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

  1. #1
    Seeker GregT's Avatar
    Join Date
    Nov 2019
    Posts
    11
    Articles
    0
    Excel Version
    2016

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Click image for larger version. 

Name:	Screenshot (37).jpg 
Views:	81 
Size:	99.4 KB 
ID:	10362
    =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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Screenshot (37).png 
Views:	8 
Size:	6.4 KB 
ID:	10361  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •