Excel Nested If

%3CLINGO-SUB%20id%3D%22lingo-sub-2594208%22%20slang%3D%22en-US%22%3EExcel%20Nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594208%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EUse%20the%20product%20code%20breakdown%20provided%20to%20create%20appropriate%20nested%20functions%26nbsp%3Bto%20complete%20the%20following%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EIf%20the%20product%20is%3CSTRONG%3E%26nbsp%3BWhite%20and%20240%20V%3C%2FSTRONG%3E%26nbsp%3Binsert%20the%20product%26nbsp%3B%3CSTRONG%3EPrice%3C%2FSTRONG%3E%2C%20otherwise%20the%20cell%20should%20be%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eblank.%20If%20anyone%20can%20help%20me%20out%20with%20a%20formula%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CTABLE%20width%3D%22840px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22114px%22%3E1st%20character%3C%2FTD%3E%3CTD%20width%3D%22135px%22%3E2nd%20character%3C%2FTD%3E%3CTD%20width%3D%22111px%22%3E5th%20character%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3E6th%20character%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3EP%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3EPremium%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ER%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3ERefrigerator%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ES%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3EStainless%20steel%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E120%20V%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3ES%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3EStandard%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ES%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EStove%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EW%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3EWhite%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E240%20V%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ED%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EDishwasher%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3EBlack%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EM%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EMicrowave%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EW%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EWall%20oven%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22114px%22%3E1st%20character%3C%2FTD%3E%3CTD%20width%3D%22135px%22%3E2nd%20character%3C%2FTD%3E%3CTD%20width%3D%22111px%22%3E5th%20character%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3E6th%20character%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EP%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3EPremium%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ER%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3ERefrigerator%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ES%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3EStainless%20steel%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E120%20V%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ES%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3EStandard%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ES%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EStove%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EW%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3EWhite%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E240%20V%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3ED%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EDishwasher%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3EBlack%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EM%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EMicrowave%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3EW%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EWall%20oven%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2271px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2594208%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594233%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594233%22%20slang%3D%22en-US%22%3ESomething%20like%20this%3A%20%3DIFERROR(IF(AND(FIND(%22W%22%2C%5Bp%20code%5D%2C5)%2CFIND(%221%22%2C%5Bp%20code%5D%2C5))%2C%5Bprice%5D%2C%22%22)%2C%22%22)%3CBR%20%2F%3Ewhere%20%5Bp%20code%5D%20is%20the%20reference%20to%20the%20product%20code%20cell(s)%20and%20%5Bprice%5D%20is%20a%20reference%20to%20the%20price%20cell(s)%3CBR%20%2F%3Ebut%20it%20is%20unclear%20if%20the%20%22W%22%20for%20White%20is%20the%205th%20character%20or%20after%20the%206th%20character.%20The%205%20above%20assumes%20it%20is%20the%205th%20but%20would%20need%20to%20be%206%20or%207%20if%20the%20%22W%22%20for%20Wall%20oven%20is%20the%205th%20character%20as%20indicated%20in%20the%20image.%3CBR%20%2F%3EAlso%20if%20the%205th%20character%20is%20color%20and%20the%206th%20character%20is%20voltage%20then%20you%20could%20simplify%20it%20to%3A%3CBR%20%2F%3E%3DIFERROR(IF(FIND(%22W1%22%2C%5Bp%20code%5D%2C5)%2C%5Bprice%5D%2C%22%22)%2C%22%22)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594225%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1114822%22%20target%3D%22_blank%22%3E%40Deval293%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%20%3DIF(%20(product%3D%22White%22)*(haveNoIdeaWhat%3D%22240%20V%22)%2C%20productPrice%2C%20%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2624633%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2624633%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3ECan%20i%20use%20this%20table%20and%20problem%20in%20my%20Microwave%20Recycling%20website.%20So%20user%20may%20show%20some%20interest%20and%20stay%20on%20my%20website.%20I%20will%20give%20you%20credits%20too.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2682334%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2682334%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3ECan%20i%20use%20this%20table%20and%20problem%20in%20my%20%3CA%20href%3D%22%26quot%3B%26lt%3BA%22%20href%3D%22https%3A%2F%2Fdigitalblocs.com%2Fseo-for-small-businesses%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdigitalblocs.com%2Fseo-for-small-businesses%2F%3C%2FA%3E%22%26gt%3BHouston%20seo%20servicewebsite.%20So%20user%20may%20show%3CBR%20%2F%3Esome%20interest%20and%20stay%20on%20my%20website.%20I%20will%20give%20you%20credits%20too.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2647919%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647919%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3ECan%20i%20use%20this%20table%20and%20problem%20in%20my%20%3CA%20href%3D%22https%3A%2F%2Fquranbeginners.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EQuran%20Lessons%20For%20Beginners%3C%2FA%3E%20website.%20So%20user%20may%20show%3C%2FP%3E%3CP%3Esome%20interest%20and%20stay%20on%20my%20website.%20I%20will%20give%20you%20credits%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2698253%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2698253%22%20slang%3D%22en-US%22%3Ethanks%20for%20sharing%20topic%20helpful%20for%20my%20site%20%3CA%20href%3D%22%26quot%3B%26lt%3BA%22%20href%3D%22https%3A%2F%2Fsuorinvape.com%2Fcollections%2Fsuorin-air-plus%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsuorinvape.com%2Fcollections%2Fsuorin-air-plus%3C%2FA%3E%22%26gt%3BSuorin%20Air%20Plus%20Pod%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Use the product code breakdown provided to create appropriate nested functions to complete the following: If the product is White and 240 V insert the product Price, otherwise the cell should be

blank. If anyone can help me out with a formula 

1st character2nd character5th character6th character       
PPremiumRRefrigeratorSStainless steel1120 V       
SStandardSStoveWWhite2240 V       
  DDishwasherBBlack         
  MMicrowave           
  WWall oven   1st character2nd character5th character6th character
       PPremiumRRefrigeratorSStainless steel1120 V
       SStandardSStoveWWhite2240 V
         DDishwasherBBlack  
         MMicrowave    
         WWall oven    
2 Replies

@Deval293 

That's like

 =IF( (product="White")*(haveNoIdeaWhat="240 V"), productPrice, "")
Something like this: =IFERROR(IF(AND(FIND("W",[p code],5),FIND("1",[p code],5)),[price],""),"")
where [p code] is the reference to the product code cell(s) and [price] is a reference to the price cell(s)
but it is unclear if the "W" for White is the 5th character or after the 6th character. The 5 above assumes it is the 5th but would need to be 6 or 7 if the "W" for Wall oven is the 5th character as indicated in the image.
Also if the 5th character is color and the 6th character is voltage then you could simplify it to:
=IFERROR(IF(FIND("W1",[p code],5),[price],""),"")