+ Reply to Thread
Results 1 to 9 of 9

If one cell says 'yes' another cell is populated with a third cells value

  1. #1
    Registered User
    Join Date
    10-31-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    5

    If one cell says 'yes' another cell is populated with a third cells value

    D19 is blank
    B19 has a value in it.
    C19 says 'Yes/No

    I need D19 to populate with B19's value if C19 says Yes. I also need D19 to show 0 if C19 says No

    Any help?

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: If one cell says 'yes' another cell is populated with a third cells value

    Assuming you can only have Yes or No in C19
    put in D19
    =If( C19="no", 0, B19)
    OR
    =IF( C19="NO", 0, IF( C19="YES", B19, "C19 does not equal Yes or No"))
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    09-25-2006
    Location
    North West, UK
    MS-Off Ver
    2010
    Posts
    73

    Re: If one cell says 'yes' another cell is populated with a third cells value

    A simple IF statemet?

    =IF(C19="Yes",B19,0)

  4. #4
    Registered User
    Join Date
    10-04-2012
    Location
    Not here, it's rubbish!
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    66

    Re: If one cell says 'yes' another cell is populated with a third cells value

    Insert this into D19
    =IF(C19="No","0",IF(C19="Yes",B19,""))

  5. #5
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: If one cell says 'yes' another cell is populated with a third cells value

    Hi, In C19

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Booşathì

  6. #6
    Registered User
    Join Date
    10-31-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    5

    Re: If one cell says 'yes' another cell is populated with a third cells value

    THANKS GUYS, THE nO FUNCTION WORKS FOR ALL BUT NONE OF THEM ALLOW THE YES FUNCTION TO WORK FOR SOME REASON

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: If one cell says 'yes' another cell is populated with a third cells value

    BUT NONE OF THEM ALLOW THE YES FUNCTION TO WORK
    check you have YES and not YES with a space in at all " YES" or "YES "

  8. #8
    Registered User
    Join Date
    10-31-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    5

    Re: If one cell says 'yes' another cell is populated with a third cells value

    Ok got it, just had an extra space. Thank you for your help guys, much appreciated.

  9. #9
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: If one cell says 'yes' another cell is populated with a third cells value

    your welcome - thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete Cells with Specific Value and All Blank Cells Until Next Populated Cell is Checked
    By rdtrahan1906 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2014, 05:50 PM
  2. [SOLVED] Divide a Cell by the number of populated cells in a column
    By MATU70 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-11-2014, 06:49 AM
  3. Lock cells if another cell is populated
    By garveyarmy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2014, 09:52 AM
  4. Replies: 11
    Last Post: 04-11-2013, 10:56 AM
  5. New to macros - script to protect cells if a particular cell is populated
    By gsandifer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2013, 04:19 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1