SOLVED
Home

Incorporating IFERROR or IF function into complicated nested formula

%3CLINGO-SUB%20id%3D%22lingo-sub-907605%22%20slang%3D%22en-US%22%3EIncorporating%20IFERROR%20or%20IF%20function%20into%20complicated%20nested%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907605%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20you%20will%20see%20in%20the%20attached%20spreadsheet%2C%20the%20below%20nested%20formula%20works%20well%20in%20columns%20C%2CD%2C%20%26amp%3B%20E%20under%20normal%20conditions%3B%20However%2C%20when%20column%20G%20differs%20in%20content%20the%20result%20is%26nbsp%3B%23VALUE!%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3DMID(%24F39%2C%3CBR%20%2F%3EFIND(%22-%22%2C%24F39)%2B1%2C%3CBR%20%2F%3EFIND(%22%20%22%2C%24F39)-FIND(%22-%22%2C%24F39)-1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20incorporate%20an%20IF%20or%20IFERROR%20function%20to%20follow%20or%20precede%20aforementioned%20formula%20above%3F%20Ideally%2C%20it%20would%20look%20something%20like%20this%2C%3C%2FP%3E%3CP%3EIF(G3%3D%22VERANDA%20PRIVACY%20LATTICE%204X8%20VINYL%20WHITE%22%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20greatly%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-907605%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907654%22%20slang%3D%22en-US%22%3ERe%3A%20Incorporating%20IFERROR%20or%20IF%20function%20into%20complicated%20nested%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907654%22%20slang%3D%22en-US%22%3E%3CP%3EC3%20Formula%3C%2FP%3E%3CP%3E%3DIFERROR(1*LEFT(%24G3%2C%3CBR%20%2F%3EFIND(%22X%22%2C%24G3)-1)%2C%22%22)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ED3%20formula%3C%2FP%3E%3CP%3E%3DIFERROR(MID(%24G3%2C%20FIND(%22X%22%2C%24G3)%2B1%2C%20FIND(%22-%22%2C%24G3)-FIND(%22X%22%2C%24G3)-1)%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE3%20Formula%3C%2FP%3E%3CP%3E%3DIFERROR(MID(%24F3%2C%3CBR%20%2F%3EFIND(%22-%22%2C%24F3)%2B1%2C%3CBR%20%2F%3EFIND(%22%20%22%2C%24F3)-FIND(%22-%22%2C%24F3)-1)%2C%22%22)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20this%20helps.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-908514%22%20slang%3D%22en-US%22%3ERe%3A%20Incorporating%20IFERROR%20or%20IF%20function%20into%20complicated%20nested%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908514%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368896%22%20target%3D%22_blank%22%3E%40Kodipady%3C%2FA%3E%26nbsp%3BWorks%20perfectly!%20Thank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
J-Griff
Occasional Contributor

As you will see in the attached spreadsheet, the below nested formula works well in columns C,D, & E under normal conditions; However, when column G differs in content the result is #VALUE!

 
 

=MID($F39,
FIND("-",$F39)+1,
FIND(" ",$F39)-FIND("-",$F39)-1)

 

Is it possible to incorporate an IF or IFERROR function to follow or precede aforementioned formula above? Ideally, it would look something like this,

IF(G3="VERANDA PRIVACY LATTICE 4X8 VINYL WHITE","")

 

Any help is greatly appreciated!

 

Cheers,

 

John 

2 Replies
Solution

C3 Formula

=IFERROR(1*LEFT($G3,
FIND("X",$G3)-1),"")


D3 formula

=IFERROR(MID($G3, FIND("X",$G3)+1, FIND("-",$G3)-FIND("X",$G3)-1),"")

 

E3 Formula

=IFERROR(MID($F3,
FIND("-",$F3)+1,
FIND(" ",$F3)-FIND("-",$F3)-1),"") 

 

hope this helps. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies