Reverse calculation on only one figure

[shukla.ankur281190]

Hi Masters,

Hope you all are doing very well.

I am stuck with a reverse calculation hope you guys will solve it.

I have table containing salary bifurcation and accumulated amount is showing after calculation but now I wish to get the automatically bifunction only on one amount.

Excel 2016 (Windows) 64 bit

	A	B	C	D	E	F	G	H	I	J	K	L	S
2			? 20,000.00
3
4	(A)	A	B	C	D	E	F	G	H	I	J	K	Custom
5	B	10500	10500	10500	10500	10500	10500	10500	10500	10500	10500	10500	21440
6	H	4200	4200	4200	4200	4200	4200	4200	4200	4200	4200	4200	8576
7	S	5,300	850	6,900	7,300	7,700	8,300	8,900	9,300	10,300	10,900	11,300	23,584
8	Gross	20000	15550	21600	22000	22400	23000	23600	24000	25000	25600	26000	53600
9	P	1,800	1,800	1,260	1,260	1,260	1,260	1,260	1,260	1,260	1,260	1,260	2,573
10	E	350	272	0	0	0	0	0	0	0	0	0	0
11	Net	17850	13478	20340	20740	21140	21740	22340	22740	23740	24340	24740	51027
12	(B)
13	LTA	0	0	0	0	0	0	0	0	0	0	0	0
14	CEL	0	0	0	0	0	0	0	0	0	0	0	0
15	Annual Gross	240,000	186,600	259,200	264,000	268,800	276,000	283,200	288,000	300,000	307,200	312,000	643,200
16	(C)
17	EG	6,058	6,058	6,058	6,058	6,058	6,058	6,058	6,058	6,058	6,058	6,058	0
18	B	16,800	16,800	16,800	16,800	16,800	16,800	16,800	16,800	16,800	16,800	16,800	0
19	EPF	21,600	21,600	15,120	15,120	15,120	15,120	15,120	15,120	15,120	15,120	15,120	30,876
20	ESIC	11,400	8,864	0	0	0	0	0	0	0	0	0	0
21	MPP	0	0	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000
22	Total Cost	295,858	239,922	307,178	311,978	316,778	323,978	331,178	335,978	347,978	355,178	359,978	684,076

Sheet: Sheet1 (2)

I am attaching herewith excelsheet for your help.

What I wish is that I just put total cost in b22 call rest above cells automatically update.

[avk]

But "b22" is your formula.

[shukla.ankur281190]

That is not a formula that cell is calculating the total amount what bifurcated in above cell. Now suppose you have a Total Amount is 300000 this amount need to bifurcate in above cells.

Hope I am clear

[avk]

I mean based on 300000 amount all data calculate as per particularly those amount only.
See attach file sheet1.