DumbEngineer
New Member
- Joined
- Nov 1, 2017
- Messages
- 5
Hi,
As the title suggests, I created a spreadsheet to keep track what bills my roommates owe. I have columns/cells that tell say what bills each individual owes. The trouble I am having comes in when trying to format cells so that they will tell me what bills people still owe after paying part of total amount. I can easily get the numerical value of what people still owe if they pay only part of the total amount, however, I want the spreadsheet to display the bill(s) they have not paid. For example, the expenses are rent, electricity, cable, and water. If a roommate has only paid the water bill but not the rent or other utilities, I want the column to say "Rent, Cable, and Electric still owed". Another example would be if a roommate only paid $100, I want the column to spit out that the roommate still owes utilities plus the amount of rent minus 100. And finally if the roommate has paid everything, I want "Paid in Full" displayed. I tried using a bunch of nested IF statements but soon realized there are well over 100 different combinations to have to go through. I was just wondering if there was a much simpler way of going about formatting the column to tell me what people still owe.
Thanks
As the title suggests, I created a spreadsheet to keep track what bills my roommates owe. I have columns/cells that tell say what bills each individual owes. The trouble I am having comes in when trying to format cells so that they will tell me what bills people still owe after paying part of total amount. I can easily get the numerical value of what people still owe if they pay only part of the total amount, however, I want the spreadsheet to display the bill(s) they have not paid. For example, the expenses are rent, electricity, cable, and water. If a roommate has only paid the water bill but not the rent or other utilities, I want the column to say "Rent, Cable, and Electric still owed". Another example would be if a roommate only paid $100, I want the column to spit out that the roommate still owes utilities plus the amount of rent minus 100. And finally if the roommate has paid everything, I want "Paid in Full" displayed. I tried using a bunch of nested IF statements but soon realized there are well over 100 different combinations to have to go through. I was just wondering if there was a much simpler way of going about formatting the column to tell me what people still owe.
Thanks
