Selected Answer

Your workbook wasn't attached to your question. I don't know if it would have helped. This is the formula I thought up. Please try it.

`=$G7 * IF($G7 <= $F7, $E7, IF($G7 < $L7, $H7,IF($G7 >= $Q7, $R7, IF($G7 > $L7, $M7,0))))`

I made two logical changes to your description. You say what to do if G7 is larger than F7 or smaller than F7 but not what should happen when it is equal to F7. Same thing between G7 and Q7. My formula chooses to multiply with E7 if G7 = F7 and multiply with R7 if G7 = Q7.

My formula will multiply with 0 (producing a result of zero) if none of the conditions are met. If you wish to have that result instead of the changes I made, remove the equal sign from >= and <= in the above formula or accommodate the possible equality by adding the equal sign in the subsequent IF.

For your understanding, the formula takes G7 and finds a multiplier for it. For this purpose it first compares G7 with F7. If G7 <= F7 a result was found. Else F7 must be larger. That leads to the second IF where the formula checks if G7 is smaller than L7 - IF($G7 < $L7, $H7 - if so a multiplier is found (you might add an euqal sign here, too). If this condition isn't met either the whole thing is basically repeated with Q7 and L7. Here is the plain language formula design which I encoded.

```
IF G7 < F7 Then G7 * E7
Else IF G7 > F7 And < L7 Then G7 * H7
Else IF G7 > Q7 Then G7 * R7
Else IF G7 < Q7 And > L7 Then G7 * M7
```