Forum Discussion
Excel12345678
Mar 05, 2023Copper Contributor
MS Excel 365 Help in Formula...
Attached excel sheet containing four qtr %
(unable to attach excel sheet ..please type formula as per below table)
Rules/ Conditions
1. 100% requirement and subsequent Qtr 80% required : Result "100% PASS"
2. Less than 80% in any quarter Result "FAIL"
3. Excess achievement in Previous Qtr will be carried forward in next Qtr provided 80% min required. -Result "100% PASS"
4.if you achievement in Less than 100 and more-than 80% you have to chance to make-up deficit in Subsequent Qtr provided min 75% in that Qtr ....Result " 85%PASS"
5. beyond Subsequent Qtr you make-up deficit then Result "60%PASS"
Please see the attachment for more clarifications...
1st | 2nd | Half | 3rd | 9Mn | 4th | Ann | Formula type below for each row | Result | Remarks | |||||
100 | 100 | 100 | 100 | 100 | 100 | 100 | Row1 | "100% Pass" | All Qtr 100% | |||||
65 | 105 | 118 | 101 | 112 | 100 | 104 | Row2 | "2nd,3rd,4th PASS" | 1st Qtr Less Than 75% | |||||
75 | 105 | 118 | 101 | 112 | 100 | 104 | Row3 | 1st Qtr85% & 2,3,4 PAss | Min 75% Condition pass and winback in 1st HAlf | |||||
131 | 60 | 118 | 101 | 112 | 100 | 104 | Row4 | 3rd & 4th PASS | Min75% ach.Fail for 1st Qtr & 2nd Qtr | |||||
131 | 105 | 118 | 101 | 112 | 100 | 104 | Row5 | |||||||
131 | 105 | 118 | 75 | 112 | 100 | 104 | Row6 | "100% Pass" | All Qtr 100% Excess in Previouse Qtr carried forward then 9mnths more than 100% | |||||
60 | 75 | 68 | 75 | 70 | 100 | 104 | Row7 | Only 4th Qtr PASS | As 100% achement for that Qtr will be passed and 75% Annual pass | |||||
No RepliesBe the first to reply