Formula Required Multiple

Question

City/Group/Product1st 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'20244th Qtr T.F.Annual T.F.ValuePune&nbsp; 102&nbsp;&nbsp;&nbsp; 109&nbsp;105&nbsp;&nbsp;&nbsp;&nbsp; 73&nbsp;&nbsp; 97&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 88&nbsp;&nbsp; 48,00,000&nbsp;&nbsp; 105&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;OLD Group&nbsp; 102&nbsp;&nbsp;&nbsp; 105&nbsp;103&nbsp;&nbsp;&nbsp;&nbsp; 75&nbsp;&nbsp; 96&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 88&nbsp;&nbsp; 37,00,000&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp; 89&nbsp;S1&nbsp;Super Product&nbsp;&nbsp;&nbsp; 82&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp; 86&nbsp;&nbsp;&nbsp;&nbsp; 81&nbsp;&nbsp; 85&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp; 25,00,000&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp; 100&nbsp;One Product&nbsp; 127&nbsp;&nbsp;&nbsp; 124&nbsp;126&nbsp;&nbsp;&nbsp;&nbsp; 66&nbsp;111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97&nbsp;&nbsp; 12,00,000&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;New Group&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 168&nbsp;&nbsp; 84&nbsp;&nbsp;&nbsp;&nbsp; 63&nbsp;&nbsp; 79&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85&nbsp;&nbsp; 11,00,000&nbsp;&nbsp; 105&nbsp;&nbsp;&nbsp;&nbsp; 81&nbsp;Cello Product&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 278&nbsp;139&nbsp;&nbsp; 132&nbsp;137&nbsp;&nbsp;&nbsp;&nbsp; 170&nbsp;&nbsp;&nbsp; 169&nbsp;&nbsp;&nbsp;&nbsp; 3,50,000&nbsp;&nbsp; 120&nbsp;&nbsp; 143&nbsp;Himalaya product&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 122&nbsp;&nbsp; 61&nbsp;&nbsp;&nbsp;&nbsp; 35&nbsp;&nbsp; 55&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp; 7,50,000&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp; 55&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AnsFormula columnCondition&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4T1L3&nbsp;OLD Product : 4th Qtr T.F. should be100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AT1L3&nbsp;OLD Product : 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100&nbsp;&nbsp;&nbsp;&nbsp;4S1L4&nbsp;Super Product: 4th Qtr T.F. should be100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AS1L4&nbsp;Super Product: 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100&nbsp;&nbsp;&nbsp;4P1L5&nbsp;One Product: 4th Qtr T.F. should be100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AP1L5&nbsp;One Product: 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100&nbsp;&nbsp;&nbsp;&nbsp;HT1L7&nbsp;Himalaya product : 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100&nbsp;&nbsp;&nbsp;CT1L8&nbsp;Cello Product : 4th Qtr T.F. Min 80 and Annual T.F. Greater than 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Note :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New group product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* if any product excess achievement (i.e. Annual T.F. is more than 100 ) will be carried forward to Super Product&nbsp;&nbsp;&nbsp;Means if any new group product excess achievement is considered for deficit of Super Product&nbsp;&nbsp;&nbsp;

harun24hr · Answer

What are you trying to do? What formula do you need? Attach a excel file and then explain what you desired.

excel12345678 · Answer

Harun24HR&nbsp;here is no option to attach or upload file....??

hansvogelaar · Answer

Excel12345678&nbsp;
Upload the workbook to Google Drive, Dropbox, Onedrive or similar, then post a link to the uploaded file that allows us to view and download it.

excel12345678 · Answer

HansVogelaar&nbsp;..&nbsp;&nbsp;https://docs.google.com/spreadsheets/d/1Z1YncXnk9iQzbPNYcT9hIfr2fb7lqczsKjvT0Jlrx5A/edit?usp=sharing&nbsp;Attached sheet we mentioned all need of formulas.&nbsp;Thanks&nbsp;

hansvogelaar · Answer

Excel12345678&nbsp;
Thanks, but I'm afraid I do not understand what you want.

Forum Discussion

Formula Required Multiple

5 Replies

Resources

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 Product