Forum Discussion
Solved
Using the If Function to select a identify a catagory a specifi cell fits into
I have a cell with a fixed number that is entered to identify how large a company may be. In another cell, I want to identify what the category is by using the IF function. There are 4 categories t...
Attached is the formula with example in the attached file.
=IF(ISBLANK(B$5), "", IF(B$5<=0.3, "Micro Cap", IF(B$5<=2, "Small Cap", IF(B$5<=10, "Mid Cap", IF(B$5<=200, "Large Cap", "Mega Cap") ) ) ) )My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
This was really helpful and I appreciate your great help with this!!!
As variant
=XLOOKUP(
B$5,
{0.3,2,10,200,1E+99},
{"Micro Cap","Small Cap","Mid Cap","Large Cap","Mega Cap"},
"", 1)