• 549K Members
• 6,295 Online
• 657K Conversations
SOLVED

Incorporating IFERROR or IF function into complicated nested formula

Highlighted
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
Highlighted
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.

Highlighted

Re: Incorporating IFERROR or IF function into complicated nested formula

@Kodipady Works perfectly! Thank you so much!

Related Conversations
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Leap year formula
Hattsoff in Excel on
4 Replies