Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to change this formula. Right now it is a guessing game on how
to get the formula to equate to the ideal value of .28. ..28=(((E5-(B5*1000*1.305/2080))-D5-C5)/(E5)) E5 represents the number I enter to try to to get to .28 B5 is a number that varies all the time, so I enter different numbers in B5 in an attempt to get to the right value so the formula equates to ..28 D5 and C5 are constants. What would the formula look like in order to have .28 be within the formula, so that I can enter any number as B5 and the result is whatever the number E5 needs to be? In other words, I want E5 to be the answer, not .28. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to reverse an Excel formula? | Excel Worksheet Functions | |||
Looking to reverse a quadratic formula, Sqrt and all?? | Excel Discussion (Misc queries) | |||
Reverse Fees Linear Formula | Excel Discussion (Misc queries) | |||
How do I create a reverse julian date formula? | Excel Worksheet Functions | |||
Is there an formula to reverse the order of a number sequence? | Excel Discussion (Misc queries) |