Call if function, mid function, type function and lookup function, and the effect is shown in the figure.
The specific formula for judging whether the project column is "patent" or "high-tech" is:
= IF(C2 & lt； > "",if (type(-- (left (C2, 1)) = 1, "patent", "hi-tech"), "")
Note: Because the number is long and in text format, the first character on the left is extracted and converted into a number, that is,-left(C2,1); Then determine the number type, which is type (). If the result is 1, it means that it is a number and a patent. If the result is not 1, it is high technology.
F column to determine the type of patent, the specific formula is:
=IF(D2= "patent", lookup (-mid (C2 C2,5, 1), {1, 2,3}, {"invention", "utility model", "appearance"}), ""),