How return an alpha value if a number falls within a range?

angyeliz

New Member
Joined
Feb 17, 2022
Messages
3
Office Version
  1. 365
Platform
  1. Windows
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 Duty1 - 10,000
Med Duty10,001 – 26,000
Heavy Duty> 26,001
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Ok I think I have it after looking at someone else's post, that took me way to long mentally lol. Sorry I don't know how to delete my question but I used this formula if anyone else runs into the same issue

=IF(A42="","",IF(A42<=10000, "Light Duty",IF(A42<=26000, "Medium Duty", "Heavy Duty")))
 
Upvote 0
You could make yourself a little table in say A1:B3 and use:

=INDEX($A$1:$A$3,MATCH(A13,$B$1:$B$3))

or if you want to hardcode the values the IF would be:

=IF(A13<10001,"Light Duty",IF(A13<26001,"Med Duty","Heavy Duty"))
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top