Current location - Information Consultation Platform - Patent Search - The number in the excel table determines the patent type. For example, the fifth digit in the patent number 201320000002 is 2, which means it is a utility model patent.
The number in the excel table determines the patent type. For example, the fifth digit in the patent number 201320000002 is 2, which means it is a utility model patent.
Intercept the fifth character and use the IF formula to judge. If there are many types, you can use LOOKUP
For example:
The patent number is A1
B1 input formula=IF(--MID(A1, 5, 1)=2, "Utility model patent", "Other patents")