Do you also try to eat your cake and have it too? Seriously, without seeing the actual spreadsheet and cell you're describing, it sounds like you're just overloading that poor cell with incompatible expectations.
If you could upload a sample so we could see it, we could make more specific recommendations. Absent that, just trying to make sense of what you've written, I'd think you would achieve your goal by splitting up the conditions that need to be met, and/or the functions that need to be performed, into two or more cells. That way you could see more clearly what's going wrong, perhaps use a conditional format rule on one or more to highlight when boundaries have been exceeded.
But upload a sample if you still need help...
