What should I do if the excel table formula statement exceeds 7 layers?

Method 1: Change to EXCEL version 20 10 to support more layers.

Method two, change the formula, change the nesting into juxtaposition, for example:

=IF(COUNTIF(T4, "* sogou *", "sogou", ").

& if (countif (T4, "* male cloth *", "chest", ").

& ampIf (countif (T4, "* Shousen *", "slimming", ").

& if (countif (T4, "*yanmeibu*", "eyebrow", ").

& if (countif (T4, "*bibu*", "nose", ").

& if (countif (t4, "* Xiaba *", "Qin", ")

& if (countif (t4, "* depilated cat *", "depilated", ").

& if (countif (T4, "* Chuzhou *", "wrinkle removal", ").

& ampIF(COUNTIF(T4，" *bahen* "，" scar "，"")

& if (countif (T4, "* Ji Guang *", "laser", ").

& if (countif (T4, "* Wei Zhengxing *", "micro-shaping", ")

& if (countif (T4, "* Zhengxing *", "Plastic", ").

& if (countif (T4, "* Hong Xuesi *", "Red Blood", ")

& if (countif (T4, "* Quban *", "Freckle", ")

& if (countif (T4, "* Tai Chi *", "Tai Chi", ").

& if (countif (T4, "*quchu*", "take it out", ").

& ampIF(COUNTIF(T4，" *simi* "，" private "，"")

& if (countif (T4, "* wide face *", "wide face", ").

& if (countif (T4, "* oral cavity *", "oral cavity", "")

& ampIF(COUNTIF(T4，“*kouchun*”，“lip”，”)

& if (countif (t4, "* soso *", "soso", ")

How many layers does this method support? Can you understand this formula? Please add any questions.