Formula to determine pitcher card average..

[mad3]

In Cell. B4 (.221) is pitchers season batting average against. In A10 (.259) Is the league batting average, . If 50 percent of results come from pitchers card, what formula would calculate what pitchers card would be in order to average .221 (B4) against a league average (A10) .259. Thanks for help with formula...

Mike in Cali...

 

[Joe4]

I am afraid the question doesn't make very much sense to me (and I am a baseball fan).
What is "pitchers card"?

Can you try explaining again, in more detail?

 

[mad3]

Ok. I'll try and explain a bit. I am trying to create cards for pitchers and hitters. I know what hitters average is based on league average. I also know what a pitcher have up for a batting average. So I'm trying to create a formula that would trek me what a created game card for a pitcher that have up .221 batting average against a league that hit .259... example. If the average hitter card hits .259 Sam's my pitcher is left at .221 on his card, he will end up with a result of .240.
Does that make sense. I need to calculate what his card needs to end up at .221 for the season, if half the time the result is going to end up. 259. What is the other half (pitcher card result) in order to end hoop at .221. And how do I calculate that with a formula.?

 

[mad3]

I know what the end result needs to be (.182), I just don't know how to put it in a formula. so I can have it auto calculate for each one.

 

[Joe4]

If you know what the end average should be, then just multiply that by 2 and subtract the one average to get the other one.
Of course, that is assumes that it is an exact 50-50 split.

 

[mad3]

Thanks! I'm going to do that first thing tomorrow.

 

[Joe4]

You are welcome!

Just as an FYI, the formula for finding the average between two values is:

Final Average = (Value1 + Value2)/2

So, the formula to find one of the values is:

Value2 = (Final Average * 2) - Value1