Thx for looking. Managers currently receive a report showing how many Passes / Fails their team received. They would now like to see a box that calculates how many passes are needed to reach the 95% goal.
Example:
2 Passes = Pass% of 66.67%
1 Fail = Fail% of 33.33%
How many more Passes are needed to achieve a 95% Pass% goal?
I've attached the spreadsheet. If you could assist I would greatly appreciate it. Thx
Row\Col H5: =MAX(0, G5*(95%-D5)/(100%-95%))
Entia non sunt multiplicanda sine necessitate
insert this formula in H5 and copy it down as needed
Please Login or Register to view this content.
Last edited by rcm; 03-03-2016 at 09:11 PM. Reason: clarity
Or simply
=MAX(0,19*E5-C5)
Happy with my advice? Click on the * reputation button below
Thx guys for the fast replies:
@rcm - pasting the code into H5 only results in it appearing to put the same values as column G already have.
Example row 5 has 4 passes and 0 fails, meaning it needs no more passes to achieve a 95% Pass percentage. Unfortunately the formula in H5 returns a value of 4, when it should return a value of 0.
@Crooza - Thx worked as intended.
@shg
Thx a lot, really appreciate the table layout.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks