Prioritising nested IF statements

[rothexcel]

I have many items which need to be classified according to either their status, range or description, depending on what each one is. The status, range and description of each of my products appear in different columns.
If the product has a "Bargain" status then it should be classified as "Bargain" and nothing else.
If the product does not have a "Bargain" status then other conditions need to be checked - If the description contains "Crossover" then it must be classified as "Crossover".
If the product does not have a "Bargain" status, and its description doesn't contain "Crossover" then it must be classified as whatever is shown in the Range column.
I have a formula which was working until I added an IF(ISNUMBER(SEARCH) formula. Now it is prioritising "Crossover" over "Bargain" and "Bargain" must have the first priority, "Crossover" the second.

Here is some of my data for reference:
[TABLE="width: 739"]
<tbody>[TR]
[TD]DESC[/TD]
[TD]RANGE[/TD]
[TD]STATUS[/TD]
[TD][/TD]
[TD]CLASSIFICATION S/BE - FORMULA TO KICK OUT[/TD]
[/TR]
[TR]
[TD]CROSSOVER COTTON N SINGLE[/TD]
[TD]CLASSICS[/TD]
[TD]BARGAIN[/TD]
[TD][/TD]
[TD]BARGAIN[/TD]
[/TR]
[TR]
[TD]BODY MAKE UP[/TD]
[TD]EVERYDAY[/TD]
[TD]REGULAR[/TD]
[TD][/TD]
[TD]FASHION[/TD]
[/TR]
[TR]
[TD]CROSSOVER COTTON N VALUE-PACK[/TD]
[TD]CLASSICS[/TD]
[TD]REGULAR[/TD]
[TD][/TD]
[TD]CROSSOVER[/TD]
[/TR]
[TR]
[TD]CROSSOVER COTTON N SINGLE[/TD]
[TD]CLASSICS[/TD]
[TD]BARGAIN[/TD]
[TD][/TD]
[TD]BARGAIN[/TD]
[/TR]
[TR]
[TD]SOFT SHAPER W[/TD]
[TD]BEAUTYFULL[/TD]
[TD]REGULAR[/TD]
[TD][/TD]
[TD]BEAUTY-FULL[/TD]
[/TR]
[TR]
[TD]TRI-ACTION MINIMIZER W[/TD]
[TD]TRI-ACTION[/TD]
[TD]REGULAR[/TD]
[TD][/TD]
[TD]TRI-ACTION[/TD]
[/TR]
</tbody>[/TABLE]


This is my current formula, but as I said the "Crossover" is being prioritised when in fact "Bargain" should be:

=IF(C3="BARGAIN","BARGAIN",IF(ISNUMBER(SEARCH("crossover",A3)),"CROSSOVER",IF(B3="EVERYDAY","FASHION",IF(B3="BASIC FIT","BEAUTY FULL",B3))))

 

[RoryA]

Welcome to the forum.

That formula will not prioritise "crossover" over "Bargain". If C3 is BARGAIN, it will return BARGAIN and then exit. If you are seeing something else, then C2 doesn't contain BARGAIN - perhaps it has a leading/trailing space?

 

[rothexcel]

My formula is actually working now.