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.