It's not as simple as that: Excel would need to understand the logic that you were using to be able to replicate the decisions you were making, and there would be far too many variables for a formula to cope with. This is verging on an AI requirement!

It can't be done. Sorry. This one's going to have to remain a manual process, I'm afraid.