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"
Bookmarks