Need to work out an equation and find a value of a number.

Question

I am trying to work out an equation for a fantasy football spreadsheet i am working on.

Lets say

1. Player A is worth $564600 (Current Value).
2. Player A has a 3 game average of 158
3. Player A projected price after 3 games is $610798

What i need what the formula is to work out this.

I have been told that it may be something like this. The $ amount is not know being the 'Magic Number'

(Current value x 0.75) + (0.25 x (3 game avg x $))

Answer 1

If current value is in A2, 3-game average in B2 and your 'magic number' in C2, your formula would be

=(A2*0.75)*(0.25*(B2*C2))

If instead, what you're trying to determine is what that 'magic number' is, put the projected price in C2 and the formula would be

=(C2-(0.75*A2))/(0.25*B2)