# Writing multi conditional formula in excel

1. ## 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"  Register To Reply

2. ## 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.``  Register To Reply

3. ## 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"  Register To Reply

4. ## 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.``  Register To Reply