Complex IF Formula

What I want to do is to use multiple IF statements in the same cell. For instance, lets use data in cells Q4 and T4, returning a value in W4.


Ok, so, a breakdown of what I want to do (hopefully all in the same cell)..

If Q4 is =/> 50,000, I need it to take Q4*10% and then look at cell T4, if T4 is over or under (negative or positive) the (Q4*10%) value, then return the difference between (Q4*10%) and cell T4.

If Q4 is < 50,000, I need it to look at cell T4, if T4 is greater than 5000, then I need it to subtract 5000-the value in T4, if T4 is less than 5000, then I want it to return a zero.

To futher complicate things, it can be +5000 or -5000. That is the tolerance -5000 to +5000, I'm searching for anything over or under that.

I hope someone can help!