Scoring the cells

[ravisandhu]

hi there experts,

I hope you can help me with this problem that I have.

You'll see in the attachment that there are a range of behaviours D3 - D13.
The behaviours have a weighting, which is dependant on their level (found in C3 - C13.

When completing the form, the user will only enter data into the range E3-E13, where they will enter 0 for false and 1 for true

These are then added in ranges G3 to H13, and the sum is worked out at the bottom of each column

This is what I need to happen in the cells I14, J14, K14 and L14.

1. When F14, G14 and H14 all equal 0 (I14 should equal 1)

2. When F14 equals 3 and G14 equals smaller than 2 (J14 should equal 1)

3. When F14 equals 3 and G14 equals more than 2 and H14 equals less than 2 (K14 should equal 1)

4. When F14 equals 3 and G14 equals 4 and H14 equals more than 2 (L14 should equal 1)

I hope you can help me make the right formula, or something similar that will help me achieve a similar outcome.

Thanks in advanced.

Ravi