Forum Discussion

Excel12345678's avatar
Excel12345678
Copper Contributor
Mar 05, 2023

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...

 

1st2ndHalf3rd9Mn4thAnn Formula type below for each rowResultRemarks    
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 PAssMin 75% Condition pass and winback in 1st HAlf    
131  60  118  101  112  100  104 Row4 3rd & 4th PASSMin75% 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 PASSAs 100% achement for that Qtr will be passed and 75% Annual pass    
               
               

 

No RepliesBe the first to reply

Resources