User Profile
Excel12345678
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Formula Required Multiple
City/Group/Product 1st QtrT.F. 2nd Qtr T.F. Half T.F. 3rd Qtr T.F. 9M T.F. Jan-Feb T.F. 10 Mnth T.F. Projected Mar'2024 4th Qtr T.F. Annual T.F. Value Pune 102 109 105 73 97 40 88 48,00,000 105 90 OLD Group 102 105 103 75 96 35 88 37,00,000 110 89 S1 Super Product 82 90 86 81 85 44 80 25,00,000 90 100 One Product 127 124 126 66 111 23 97 12,00,000 120 99 New Group - 168 84 63 79 67 85 11,00,000 105 81 Cello Product - 278 139 132 137 170 169 3,50,000 120 143 Himalaya product - 122 61 35 55 24 50 7,50,000 90 55 Ans Formula column Condition 4T1 L3 OLD Product : 4th Qtr T.F. should be100 AT1 L3 OLD Product : 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100 4S1 L4 Super Product: 4th Qtr T.F. should be100 AS1 L4 Super Product: 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100 4P1 L5 One Product: 4th Qtr T.F. should be100 AP1 L5 One Product: 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100 HT1 L7 Himalaya product : 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100 CT1 L8 Cello Product : 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100 Note : New group product * if any product excess achievement (i.e. Annual T.F. is more than 100 ) will be carried forward to Super Product Means if any new group product excess achievement is considered for deficit of Super Product952Views0likes5CommentsMS 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 pass487Views0likes0CommentsRe: Help In Formula IF Nested
Rajesh_Sinha Thanks....but I have Query 1. how formula find division of Delhi-VCD or Delhi-PHD from master sheet..? 2. formula should based on master sheet Criteria …if P then two condition above 100% - (Additional 120% in fixed amount) and above 90% (as it is fixed amount) 3. but Division is V then one condition only above 100%969Views0likes1Comment
Recent Blog Articles
No content to show