Sorry if this has been asked but I'm unable to find anything that fits what I am needing and I am stumped. I have a column of numbers and in another column I want it to tell me if the number falls within a range then I want it to give the classification I have for that range. For example my classifications are below, and if my cell has a a weight of 38,000 then I want the return of Heavy Duty. Using =IF(A13<=1000,"Light Duty",IF(A13>26000,"Heavy Duty")) just returns the light and heavy, so I have no clue how to add medium. Any help is appreciated as there are over 3k entries.
Light Duty | 1 - 10,000 |
Med Duty | 10,001 – 26,000 |
Heavy Duty | > 26,001 |