I am looking to input formulas in the yellow cells the genorate the separation automatically. I am sure i can use nested if statments to solve but I would prefer to keep the solution as simple as possible. Total in the orange row is constantly changing & i would like the table to adjust...