Results 1 to 1 of 1

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

  1. 2021-03-01, 03:21 PM #1
    GregT
    GregT is offline
    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: 78  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  
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

Gravatar by 1e2.it