![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]() Code:
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 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. |
#3
|
|||
|
|||
![]()
Thanks! you save me
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Laurie B. | Excel | 4 | 08-15-2011 10:27 PM |
how to set an equation with three conditions? | Jamal NUMAN | Word | 0 | 07-09-2011 06:05 AM |
![]() |
david_benjamin | Excel | 2 | 04-11-2011 11:30 AM |
![]() |
bundy5150 | Excel | 4 | 02-22-2011 10:00 AM |
![]() |
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |