Jun 02 2018
09:31 PM
- last edited on
Jul 31 2018
08:20 AM
by
TechCommunityAP
Jun 02 2018
09:31 PM
- last edited on
Jul 31 2018
08:20 AM
by
TechCommunityAP
Hi
I'm trying to create a spreadsheet which should be simple enough but I'm having some trouble,
So basically I just want the spreadsheet to tell me how much each party should be contributing towards total expenses based on their incomes. They should only ever have a 50/50 split if their incomes are equal. Otherwise, I want the split to be in proportion to their total income.
Jun 02 2018 09:57 PM
For the amount he pays:
= C15*F7/(F7+F12)
For the amount she pays:
= C15*F12/(F7+F12)