+ Reply to Thread
Results 1 to 2 of 2

If condition based on the values

  1. #1
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    If condition based on the values

    Hi Team,

    Need help with an IF condition formula.

    i have a list in coloumn A. The list has numbers like 111, 14523..etc, blanks, and a word like "vacant".

    i am looking for an IF condition formula like this - If A2 has a number, the result should be "Ok", If A2 has a word "Vacant", the result should be "Vacant Seat", If A2 is blank, the result should be "Not Ok".

    Requesting your kind help.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: If condition based on the values

    Try

    =if(A2="vacant","vacant seat",if(A2="","not ok","ok"))
    Happy with my advice? Click on the * reputation button below

+ 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. Pick out top ten values based on 1 condition
    By batchjb69 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2014, 08:52 AM
  2. Average Values based on Condition
    By flyn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2011, 09:23 AM
  3. Retrieve values based on two condition
    By roshankp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2010, 06:04 AM
  4. Sum the values in cells based on the condition
    By deviaug28 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2009, 08:14 PM
  5. Add values in a column based on condition
    By finder003 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2007, 07:16 PM

Tags for this Thread

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