+ Reply to Thread
Results 1 to 2 of 2

Add condition

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

    Add condition

    Hi Team,

    i am already using a formula in which i need to add a condition.

    Existing formula - =IF(ISNUMBER(MATCH(K4,{"Cancelled","On Hold","Onboarded","Open","Profile Available","Profile shared","Rebadge"},0)),IF($AG$1+X4>T4,$AG$1+X4,T4),R4)

    i need to replace R4 (at the end of the formula) with this condition - if (R4>T4),R4,T4

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Add condition

    =IF(ISNUMBER(MATCH(K4,{"Cancelled","On Hold","Onboarded","Open","Profile Available","Profile shared","Rebadge"},0)),IF($AG$1+X4>T4,$AG$1+X4,T4),if (R4>T4,R4,T4))
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. [SOLVED] IF the condition of gender is met AND the condition of age is met subtract this number
    By arsenalmom in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-16-2014, 11:16 PM
  2. [SOLVED] Help for if condition formula result only either hit or miss from mulitple condition
    By breadwinner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 07:29 AM
  3. Replies: 6
    Last Post: 05-06-2010, 10:06 PM
  4. Running an if condition looped with another if condition in VBA
    By anuj.agarwal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2010, 08:12 PM
  5. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1