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