+ Reply to Thread
Results 1 to 4 of 4

Writing multi conditional formula in excel

  1. #1
    Registered User
    Join Date
    12-26-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Writing multi conditional formula in excel

    Can any please let me know can i wirite below formula in excel:

    IF D1=1033 THEN TAKE IT AS "FG"
    IF C1=MR25 OR MR26 OR MR27 AND D1<>1033 THEN TAKE IT AS "SPARES"
    IF D1="2000"AND A1 IS ENDING WITH "A1" OR "A2" OR "A3" TAKE IT AS "WIP"
    IF D1="2000"AND A1 IS NOT ENDING WITH "A1" OR "A2" OR "A3" TAKE IT AS "REVAI"
    IF A1 STARTING WITH "FA" THEN TAKE IT AS "TOOLS"
    IF A1 STARTING WITH "PI" THEN TAKE IT AS "ROSWELL"
    IF D1 STARTING WITH "5" THEN TAKE IT AS "TOOLS"
    IF D1 = "2013" OR "2014" THEN TAKE IT AS "SPARES"
    IF D1 STARTING WITH "4" OR "9"THEN TAKE IT AS "CONSUMABLES"

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Writing multi conditional formula in excel

    Assuming your order to be per above (and explicit) then given XL2007 you could get away with:

    Please Login or Register  to view this content.
    If the order of precedence is not as described please advise.

  3. #3
    Registered User
    Join Date
    12-26-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Writing multi conditional formula in excel

    Dear Sir,
    Thanks for your valuable reply, the given forumlae is correct as per my equation.
    After i see the results i came to know that my equation was worong, Now please find the corrected equation, and request you to develop formulae with this, changes are writen in small letters :

    IF D1=1033 THEN TAKE IT AS "FG"
    if c1=mr02 then take it as "nxr" new condition which was earlier not there
    IF A1 STARTING WITH "FA" THEN TAKE IT AS "TOOLS"
    IF A1 STARTING WITH "PI" THEN TAKE IT AS "ROSWELL"
    IF D1="2000"AND A1 IS ENDING WITH "A1" OR "A2" OR "A3" TAKE IT AS "WIP"
    IF D1="2000"AND A1 IS NOT ENDING WITH "A1" OR "A2" OR "A3" TAKE IT AS "REVAI"
    IF C1=MR25 OR MR26 OR MR27 AND D1<>1033 OR d1<>2000 and a1 is not starting with "fa" or "pi" THEN TAKE IT AS "SPARES"
    IF D1 STARTING WITH "5" and c1="mr01" and a1 is not starting with "fa" or "pi" THEN TAKE IT AS "TOOLS"
    IF D1 = "2013" OR "2014" and c1="mr01" and a1 is not starting with "fa" or "pi" THEN TAKE IT AS "SPARES"
    IF D1 STARTING WITH "4" OR "9" and c1="mr01" and a1 is not starting with "fa" or "pi" THEN TAKE IT AS "CONSUMABLES"

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Writing multi conditional formula in excel

    Again, this is only feasible given your use of XL2007 (or above) and order of precedence taken as explicit from your list

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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