Find value based on given percent and another value

0

10 = Total Reviewed

5 = Total Error

50.00% = Quality (A3=1-A2/A1) & Percent Format to cell       

What should be "total reviewed" value to get 85% quality when "total error" is 5? (result required in new cell (A4))

Note: "total error" (5) is a variable value

Answer
Discuss

Answers

1
Selected Answer

Presume that
L = Lot (Reviewed quantity), 
F = Faults found, and
Q = Quality level (Percentage of good products)

Now the formula you developed for calculating Q is as follows.

Q = 1 - (F / L)

Using simple rules for manipulating equations, you can determine the value of any third component of this formula if the two others are known. You learned this when first manipulating equations in - let me guess because I forgot - 7th grade. Remember? First resolve the parentheses:-

1 - Q = F / L

Therefore,

(1 - Q)L = F
and
L = F / (1 - Q)

and, for good measure,

F = (1 - Q)L
Discuss

Discussion

Thank you very much :)
narendra_749yahoocom (rep: 12) Jun 3, '17 at 1:13 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login