Foo - Excell formula help

Accuracy on excel, the following formula is used:

((A2-B2)/A2)*100


Where A2 is the amount of submitted, and B2 is the amount of rejected, the results is the accuracy rate.

Example A2 is 100 submission.
B2 is 1 reject.
The result is 99. So, 99% accuracy.


So, if I wanted to create a formula to determine how much more to add to A2 to keep the accuracy rate above a given point (let's say 97 or 98%).

I'd need help.

So.

Help!

Wouldn't you want the reject rate to be lower in order to keep your accuracy rate up? Better to have lower rejects than higher overall numbers to allow for more rejects.

I'm not sure how I'd write that one, however. Did you try using the "Solver"?

So, if I wanted to create a formula to determine how much more to add to A2 to keep the accuracy rate above a given point (let's say 97 or 98%).


A2 = B2/(1-x), where x=0.97 or 0.98, or whatever level of accuracy you want, but less than 1.

Better check her work. :D

A2 = B2/(1-x), where x=0.97 or 0.98, or whatever level of accuracy you want, but less than 1.
+1 to the nth

Wouldn't you want the reject rate to be lower in order to keep your accuracy rate up? Better to have lower rejects than higher overall numbers to allow for more rejects.

I'm not sure how I'd write that one, however. Did you try using the "Solver"?

Ideally, there would be no rejects. With out going into to much detail, there are provisions being taken to increase it. However, setting the standard at 98%, one method of ensuring they submit quality items is that they understand the ramifications of a reject.. I.E. the rework, the customer end, as well as how much work they'd have to do in order to get back up to a higher over all. Quantity isn't neccisarily the answer, but it is one motivator.

NaN

NaN

NAN.. ESMO and DMO... DMO looses to NSIPS. Are pn/dk/ps?

A2 = B2/(1-x), where x=0.97 or 0.98, or whatever level of accuracy you want, but less than 1.

Hmm.. didn't seem to work.