+ Reply to Thread
Results 1 to 4 of 4

If 2 cells = outcome formula

  1. 08-07-2018, 05:53 AM #1
    K-Linerz
    K-Linerz is offline
    Registered User
    Join Date
    06-24-2015
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    76

    If 2 cells = outcome formula

    Hi, im looking for the right formula to give me the following outcome .


    If Cell contains the word "Survey" and the Cell next to it is not blank, then I want the outcome as "Confirmed", or "Unconfirmed"

    Can you help please?

    Thanks

    Nath'
    Reply With QuoteRegister To Reply
  2. 08-07-2018, 05:55 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,435

    Re: If 2 cells = outcome formula

    Try this:

    =IF(AND(A1="Survey",B1<>""),"Confirmed","Unconfirmed")
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-07-2018, 06:10 AM #3
    K-Linerz
    K-Linerz is offline
    Registered User
    Join Date
    06-24-2015
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    76

    Re: If 2 cells = outcome formula

    Fantastic! Works perfect - Thank you Ali.

    *I did try to Add to Reputation but youre the last person I gave it to so need to give to others ha.

    Thanks

    Nath'
    Reply With QuoteRegister To Reply
  4. 08-07-2018, 06:12 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,435

    Re: If 2 cells = outcome formula

    Don't worry about the rep - it's nice if you can, but not at all necessary. It's enough to know that I helped and to have been thanked for doing so.

    If that takes care of your original question, 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. Variable keeps putting outcome on all previous cells
    By jeroen78 in forum Excel General
    Replies: 2
    Last Post: 10-14-2016, 07:11 AM
  2. Is there any way to automatically color code cells, based on formula outcome?
    By crisancomis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 03:40 AM
  3. [SOLVED] How can cells have outcome but no formula inside?
    By pabloponza in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2013, 10:53 PM
  4. How do I make a cell with a value in it prompt another cells outcome
    By Rickm12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2013, 05:53 PM
  5. [SOLVED] outcome of a cell dependent an value of a set of 3 cells
    By matwalker in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2013, 11:08 AM
  6. Outcome of VBA code to Excel Cells
    By sanits591 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2011, 08:33 AM
  7. If then else based on outcome of cells.find
    By Jeroen1000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2010, 05:20 AM

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