Related to formula

[Tariq123]

If A1 cell have value 45 and A2 have 22. So based on these 2 values I need to split in some different specific cells. I want to split these value as C1=20, C2=20 C3=5+15 mean remaing from A1 and should add 15 from A2. and last C4=7. Mean if i put 45 in specific cel excel should split in 20 20 5 and i put 22 in another cell should add 15 in last cell and remaing 7 in another cell. How its posible with formula

 

[HarryP96]

It's quite difficult to follow what you are looking to do. Could you provide screenshots to demonstrate what you're talking about?

 

[Peter_SSs]

Welcome to the MrExcel board!

It is also somewhat unclear to me. MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Taking a guess, is this what you are after?

22 11 06.xlsm
	A	B	C
1	Data		Result
2	45		20
3	22		20
4			20
5			7
6
7
Sheet2 (2)

Cell Formulas
Range	Formula
C2:C7	C2	=IF(SUM(C$1:C1)=SUM(A$2:A$3),"",MIN(SUM(A$2:A$3)-SUM(C$1:C1),20))

 

[Tariq123]

It's quite difficult to follow what you are looking to do. Could you provide screenshots to demonstrate what you're talking about?

 

[Peter_SSs]

We cannot copy from an image like that to test with your sample data. With XL2BB that I mentioned above, we can.

 

[Tariq123]

It's quite difficult to follow what you are looking to do. Could you provide screenshots to demonstrate what you're talking about?

 

[Tariq123]

This is a excel sheet where I explain briefly please see the attached file