+ Reply to Thread
Results 1 to 3 of 3

help on a simple if text says this input that, if cell is blank leave it blank

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    5

    help on a simple if text says this input that, if cell is blank leave it blank

    Hi,

    anyone can help with a simple formula for me?

    if A1 says "Active" put "Working" in A2, if A1 says "Inactive" put "Disabled" in A2, if A1 is blank, leave A2 blank.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,196

    Re: help on a simple if text says this input that, if cell is blank leave it blank

    A few options...

    =IF(A1="Active","Working",IF(A1="Inactive","Disabled",""))

    =IF(A1<>"",CHOOSE(MATCH(A1,{"Active","Inactive"},0),"Working","Disabled"),"")

    =IF(A1<>"",LOOKUP(A1,{"Active","Inactive"},{"Working","Disabled"}))
    HTH
    Regards, Jeff

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: help on a simple if text says this input that, if cell is blank leave it blank

    welcome to the forum, Rec1ne.
    =IF(A1="","",IF(A1="Active","Working","Disabled"))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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. Leave cell result blank if blank cell is in formula
    By Grind in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-28-2013, 06:15 AM
  2. Replies: 2
    Last Post: 09-20-2013, 01:43 PM
  3. [SOLVED] If cell Blank, then Leave blank, else do this
    By Hood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-05-2013, 10:35 AM
  4. [SOLVED] Simple pull exact text from cell, if blank it pulls up a 0. How to leave it as blank?
    By sharpmel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2012, 02:20 PM
  5. Replies: 4
    Last Post: 07-15-2008, 01:42 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