This unit when the production is located in cell A1, average output value of all units located in B1
, calculated according to its current value of the points of this unit, add and subtract standard (this unit when the output of the average annual output value of all units have to 2 points,
Each all units average more than 1%, and 0.02 points, the more 1 minute,
For every 1% below average output value of all units, minus 0.05 points, 0.25 points, most)

CodePudding user response:

No master excel

CodePudding user response:

=the IF (A1 & gt; B1, the IF ((A1, B1)/B1 & lt; 0.5, 2 + INT (B1) (A1 -/B1 * 100) * 0.02, 3), the IF (A1 & lt; B1, the IF ((B1 - A1)/B1 & lt; 0.05, 2 - INT ((B1 - A1)/B1 * 100) * 0.05, 1.75), 2))
Ace is not, pass by,,,