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! =M...

Book2.xlsx11 KB

excel

Formulas and Functions

Kodipady
Oct 11, 2019
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.