Conditional formula

[nsd3]

Hi,

I have attached a small part of a customer list, where I need to put a Class "H" or Class "K" on Column O based on the following criteria:

1) Put Class A If Total 2010 Sales is > $16,000, But if there was no sales in 3 consecutive Months after first month of sales then the class should be K

2) B If Sales Range is between $8,000 - $15,999 But if there was no sales in 3 consecutive Months after first month of sales then the class should be K

3) C If Sales Range is between $5,000 - $14,999, But if there was no sales in 3 consecutive Months after first month of sales then the class should be K

4) D If Sales Range is between $2,000 - $4,999, But if there was no sales in 3 consecutive Months after first month of sales then the class should be H

5) E If Sales Range is <$2,000 But if there was no sales in 3 consecutive Months after first month of sales then the class should be H

There are some #N/A in some cells. Any help would be highly appreciated.

Thanks in advance.

[DonkeyOte]

One approach:

Please Login or Register  to view this content.

use P to avoid repetitive calcs.