Hello Excel Guru's
I could do with your collective help on this task.
There is a function in Excel called Goal Seek which I know how to use but what I actually need to have is a formula that mimics this function.
My scenario is as follows:
Cell A1 = 13.50 - derived by formula
Cell A2 = 30.00 - derived by formula
Cell A3 = 687,500.00
Cell A4 = variable value but for now the value = 1
Cell A5 = A4(A2-A1)
Using goal seek, I set Cell A5 to equal Cell A3 by changing Cell A4. That gave me a value.
Now, what would the formula be to mimic that series of calculations to arrive at the answer?
I hope I have explained my request correctly...
I could do with your collective help on this task.
There is a function in Excel called Goal Seek which I know how to use but what I actually need to have is a formula that mimics this function.
My scenario is as follows:
Cell A1 = 13.50 - derived by formula
Cell A2 = 30.00 - derived by formula
Cell A3 = 687,500.00
Cell A4 = variable value but for now the value = 1
Cell A5 = A4(A2-A1)
Using goal seek, I set Cell A5 to equal Cell A3 by changing Cell A4. That gave me a value.
Now, what would the formula be to mimic that series of calculations to arrive at the answer?
I hope I have explained my request correctly...