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 return that value.
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!
Bookmarks