Hello everyone, I was wondering if someone can help me with a 6 conditions formula.

And I have the following information:

Score Target Month 1 Month 2 Month 3 Month 4 Month 5 Month 6
2 90 100 100 100 100 100 0

So the 6 conditions are:



1. When the 6 months are above target score it 2
2. If 5 out of 6 months are above target score it 2
3. If month 4 is > than the average of month 1,2 and 3.
4. If 2 months are above target score it 1
5. If 4 of the months are below target socre it 0
and 6. if all months are below target score it 0.

Im breaking my head and I really hope someone can give me a hand.

If you create a lookup table off to the right indicating what "counts" begin what score level (see picture) then you can simply COUNT how many cells are >= to your target score in that lookup table and pull back the appropriate score.

Attached Images

VlookupScore.jpg (61.6 KB, 20 views)

Thanks! you save me