I'm trying to make a spreadsheet to split the house bills with my SO.
I want to split the bills accordingly to our income so (the values are dummy)
incomeA = 1000;
incomeB = 600;
percA = incomeA / (incomeA + incomeB); (0.625)
percB = incomeB / (incomeA + incomeB); (0.375)
This is "our 50/50" and, in most of the bills is ok. If we have a bill of 40, I will play 25 (40 * 0.625) and she will pay 15 (40 * 0.375).
Now, let's say that we have a bill that I want to pay more than the "our 50/50" (75/25, for example) How can I translate our 50/50 ratio into that 75/25?
I don't really know how to put this in better words. Thanks in advance