+ Reply to Thread
Results 1 to 9 of 9

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

  1. 10-31-2014, 07:19 AM #1
    spurnell
    spurnell is offline
    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?
    Reply With QuoteRegister To Reply
  2. 10-31-2014, 07:25 AM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

    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.
    Reply With QuoteRegister To Reply
  3. 10-31-2014, 07:27 AM #3
    Althas
    Althas is offline
    Registered User
    Join Date
    09-25-2006
    Location
    North West, UK
    MS-Off Ver
    2010
    Posts
    75

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

    A simple IF statemet?

    =IF(C19="Yes",B19,0)
    Reply With QuoteRegister To Reply
  4. 10-31-2014, 07:29 AM #4
    kyjae
    kyjae is offline
    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,""))
    Reply With QuoteRegister To Reply
  5. 10-31-2014, 07:53 AM #5
    boopathiraja
    boopathiraja is offline
    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?
    Reply With QuoteRegister To Reply
  6. 10-31-2014, 07:55 AM #6
    spurnell
    spurnell is offline
    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
    Reply With QuoteRegister To Reply
  7. 10-31-2014, 07:58 AM #7
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

    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 "
    Reply With QuoteRegister To Reply
  8. 10-31-2014, 08:00 AM #8
    spurnell
    spurnell is offline
    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.
    Reply With QuoteRegister To Reply
  9. 10-31-2014, 08:24 AM #9
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

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

    your welcome - thanks for the rep
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Is it possible for 1 cell to total 1 column if populated, but if not to add up other cells
    By clairebear32 in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1