+ Reply to Thread
Results 1 to 7 of 7

Creating a formula that requires a cell to be populated

  1. 06-16-2018, 11:46 AM #1
    BigT99
    BigT99 is offline
    Registered User
    Join Date
    12-20-2016
    Location
    Wiltshire, England
    MS-Off Ver
    365
    Posts
    3

    Creating a formula that requires a cell to be populated

    Hello

    I have a formula =IF((G14="correct result"),3,0), which obviously puts a "3" into the cell if G14 has "correct result" in it. However, this is dependent on cell C14 being populated. If C14 is empty, I'd like a zero, or blank, result.

    Is this possible, and if so I'd really appreciate some guidance?

    thanks

    Tony
    Reply With QuoteRegister To Reply
  2. 06-16-2018, 11:52 AM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,911

    Re: Creating a formula that requires a cell to be populated

    Maybe:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    BSB
    Reply With QuoteRegister To Reply
  3. 06-16-2018, 11:53 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,379

    Re: Creating a formula that requires a cell to be populated

    Why is it dependent on C14? C14 is not mentioned in the formula. Do you mean this?

    =IF(G14="","",IF(G14="correct result",3,0))

    EDIT: Go with BSB's solution - I think I missed the crux.
    Last edited by AliGW; 06-16-2018 at 12:02 PM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 06-16-2018, 12:11 PM #4
    BigT99
    BigT99 is offline
    Registered User
    Join Date
    12-20-2016
    Location
    Wiltshire, England
    MS-Off Ver
    365
    Posts
    3

    Re: Creating a formula that requires a cell to be populated

    Thanks, BSB.

    It looks a simple answer, but I've struggled every time there's a big tournament to get it right. Worked first time.

    Tony
    BigT99
    Reply With QuoteRegister To Reply
  5. 06-16-2018, 12:12 PM #5
    BigT99
    BigT99 is offline
    Registered User
    Join Date
    12-20-2016
    Location
    Wiltshire, England
    MS-Off Ver
    365
    Posts
    3

    Re: Creating a formula that requires a cell to be populated

    Thanks Ali

    Can't see how to put "solved" on this though.

    Tony
    BigT99
    Reply With QuoteRegister To Reply
  6. 06-16-2018, 12:12 PM #6
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,911

    Re: Creating a formula that requires a cell to be populated

    Only easy when you know how mate

    Glad I could help.

    BSB
    Reply With QuoteRegister To Reply
  7. 06-16-2018, 12:13 PM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,379

    Re: Creating a formula that requires a cell to be populated

    Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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. [SOLVED] Return last populated cell from column to the left until next populated cell occurs
    By abx in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-23-2017, 11:40 AM
  2. I don't want dates to be automatically populated until the cell is populated
    By SBC004 in forum Excel General
    Replies: 3
    Last Post: 09-30-2016, 10:48 AM
  3. [SOLVED] Pasting a formula to last populated cell using VBA
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2016, 05:27 PM
  4. Excel Formula: If Cell Is Populated
    By leviathan86 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2013, 10:09 AM
  5. formula for displaying a cell when another is populated
    By gurj_sandhu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-17-2008, 11:18 AM
  6. include in formula only if cell is populated?
    By themax16 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2005, 02:46 PM
  7. [SOLVED] Creating new series requires div cell val by itself . How to do t.
    By Texastom in forum Excel General
    Replies: 1
    Last Post: 03-21-2005, 07:06 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