Find the lowest value that causes an equation to be greater than zero?
I need to find x in x-(x*y)-(x*z)-v when x-(x*y)-(x*z)-v is greater than zero.
x and v are currency
y and z are percentages
y, z and v are known : as in X-(X*.09)-(X*.15)-525
Here X would be $690.79 and the total of X-(X*.09)-(X*.15)-525 is .0004
I need to reverse this somehow to find x for scenarios where y, z and v are changing.
TIA
x and v are currency
y and z are percentages
y, z and v are known : as in X-(X*.09)-(X*.15)-525
Here X would be $690.79 and the total of X-(X*.09)-(X*.15)-525 is .0004
I need to reverse this somehow to find x for scenarios where y, z and v are changing.
TIA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
FANTASTIC ! Many thanks! I cannot believe how fast you did that!
Well then,
You can write this as:
X-(X*Y)-(X*Z)-V=X*( 1-Y-Z)-V
Then:
X*(1-Y-Z)-V=0 ==> X*(1-Y-Z)=V and thus X=V/(1-Y-Z)
This is a function that calculate the lowest value for X when is X-(X*Y)-(X*Z)-V greater than zero.
regards
Nrisimha