Results 1 to 5 of 5

IF condition based on multiple text values

Threaded View

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

    IF condition based on multiple text values

    hi Team,

    i have 3 coloumns in which the coloumn A will have different status like Open,Closed, Availaible etc. Coloumn C have dates. i am trying to put a formula in coloumn B.

    This is what i am looking for:

    If the cell in coloumn A is "Open" or "Availaible", Date in Coloumn C - today's date - 35. For all other status in coloumn A, coloumn B should be blank.

    Attached is the sheet.

    Please help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VLOOKUP Multiple Values then give answer based on condition
    By Wetfloor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2014, 10:24 AM
  2. [SOLVED] Get set of multiple values from a table based on condition
    By coolfundaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2013, 10:53 AM
  3. split text files stored in some location to multiple files based on a condition
    By GIRISH_KH in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2013, 11:32 AM
  4. [SOLVED] Extracting multiple values based on the condition...Pls help (Urgnt)
    By krratheesh80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2012, 10:06 AM
  5. Sum values from multiple worksheets based on a condition
    By ledisnomad in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-15-2010, 11:26 AM

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