Complex "if" "or" "else" statement for ABC analysis

**TheDanee** · 02-06-2013, 08:24 AM

Hi there,

This is my first post so please don't be too hard on me!

I just started as an intern at a company in Denmark where I live.
My university degree is within corporate communication and therefore I am not that experienced using Excel.

My supervisor has asked my to conduct an ABC analysis to see which of our clients spend the most.

I have three columns: "name of customer", "how much have they spend" and "how many orders have they placed".

If a client spent more than $2500 OR had 10 or more orders he is considered an A customer

If the client spent less than $500 OR had 3 or less orders he is considered an C customer.

All customers between these numbers (2499-499) OR (9-4) are B customers.

Can somebody help me?

TheDane

**Pepe Le Mokko** · 02-06-2013, 08:28 AM

Perhaps

Please Login or Register  to view this content.

**benishiryo** · 02-06-2013, 08:34 AM

hi TheDanee, welcome to the forum. a little confusing since your last criteria is 2499-499, i assume A must be greater OR equals to 2500 & B is lesser OR equals to 500. so mine would be:
=IF(OR(B2>=2500,C2>=10),"A Customer",IF(OR(B2<=500,C2<=3),"C Customer","B Customer"))

i think in Denmark, you might be using semi-colons. if so, try:
=IF(OR(B2>=2500;C2>=10);"A Customer";IF(OR(B2<=500;C2<=3);"C Customer";"B Customer"))