|Try starting at the big numbers and work to the small numbers,|
so the logic cascades down.
Something like this: (untested)
By way of a quick explanation, Excel stops processinng at the first TRUE statement.
In your formula, the first statement will evaluate true when any value greater that 120 is entered so processing stops and you get 400,