I have a set of values (W1, X1 and T1). Via some magic, the combination of these numbers result in a number X2.
The full spreadsheet is here, but the gist of the problem looks like this:
W1 X1 T1 X2 (Result) 2 51,900 9 36,400 2 37,600 24 27,400 3 92,800 17 55,500 3 80,200 10 46,300 4 94,800 9 49,000 4 71,900 20 38,700
I am trying but failing to come up with a formula that where W1, X1 and T1 would produce X2. The result doesn't need to match X2 perfectly, but at least come close to the result.
How would I come up with a formula for deriving X2?