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.

mumbles Wrote:
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 equate
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.

B5 = (((.28 - 1)*E5)+C5+D5)/(1000*1.305/2080)

The only difference should be that this function is defined when E5 =
whereas your function above is not.

Scot

--
Maistry
-----------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...fo&userid=3607
View this thread: http://www.excelforum.com/showthread.php?threadid=56307

mumbles Wrote:
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 equate
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.

Ha, misread it at first, was solving for B5.

I think it should be:

E5 = ((B5*1000*1.305/2080)-D5-C5)/(.28-1)

Scot

--
Maistry
-----------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...fo&userid=3607
View this thread: http://www.excelforum.com/showthread.php?threadid=56307

mumbles Wrote:
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 equate
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.

Eventually...

anyway.

=((-B5*1000*1.305/2080)-D5-C5)/(.28-1)

Scot

--
Maistry
-----------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...fo&userid=3607
View this thread: http://www.excelforum.com/showthread.php?threadid=56307

Thanks! your first one was correct =(((.28 -
1)*E5)+C5+D5)/(1000*1.305/2080) except that it gives me a negative
number
Maistrye wrote:
mumbles Wrote:
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.

Eventually...

anyway.

=((-B5*1000*1.305/2080)-D5-C5)/(.28-1)

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563075