=IF(Team A wRC+ > Team B wRC+,"Team A","Team B")
wRC+ correlates very well with winning.
Let's work with this. Clearly I can't use wRC+ in high school baseball, though...
To the best of my knowledge, the best I can do is OPS. Is there a way I can link an excel file to these posts? That way you guys could see the numbers we're working with.
If I do the IF function, it just picks the team with the higher OPS. I don't need a function to state the obvious lol.
If I know what goes into wRC+ you most certainly can calc wRC+. Then again, you will have to figure out the run value of everything according to the league. That I have no clue how to do.
Your condensed formula should work. Much easier to do IF statements if you have other cells do the calculations.
I'd have to play around in excel to figure out how to get the actual probability of who is going to win and you could run probability on what the score will be.