I want to set up a spreadsheet where the first €25000 goes to one person. After that the next €35000 is divided with the second person getting 70% and the first adding to his €25,000 by getting 30%. When the €60,000 treshold is reached everything after that is 50/50 . Any help would be appreciated. I cannot get my head around the formulas required.