• 409K Members
• 11.6K Online
• 466K Conversations
SOLVED

## Incorporating IFERROR or IF function into complicated nested formula

Occasional Contributor

# Incorporating IFERROR or IF function into complicated nested formula

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

# Re: Incorporating IFERROR or IF function into complicated nested formula

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.

# Re: Incorporating IFERROR or IF function into complicated nested formula

@Kodipady Works perfectly! Thank you so much!

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