I am creating a database for a coworker. He has various football helmets that are labeled 1-363. Each helmet has a size and we need a cell to auto populate the size when the user enters the helmet number. The problem is that the sizes of the helmets is not consistent to the helmet number. For instance, helmets 1,3,17,22,34 and 98 are XX-Small, helmets 2,4,24,25,26,27,28, 67,78 are smalls, ETC.
How do I write an if statement to produce the size with those numbers? Right not I am going number by number but this formula is extremely long. Thanks in advance!
How do I write an if statement to produce the size with those numbers? Right not I am going number by number but this formula is extremely long. Thanks in advance!
