Utility Calculator

**jbj9267** · 02-07-2012, 03:59 AM

I'm trying to have totals auto calculate based on formulas so that I can quickly find out how much each person owes, but I'm stuck in understanding how to format this when we are not splitting it equally due to non-use.

**TMS** · 02-07-2012, 04:14 AM

Add up the total days present, 27 + 29 + 29, and divide that into the total cost for a daily tariff. Then the first person pays 27 x the daily tariff and the others pay 29 x the dily tariff.

Regards, TMS

**jbj9267** · 02-07-2012, 04:16 AM

Great, thanks. How would I include that in the Excel sheet to auto calculate that? Is there something you would be willing to edit and reattach so I could understand clearer? Any help is appreciated.

**TMS** · 02-07-2012, 05:04 AM

See attached updated example.

**jbj9267** · 02-07-2012, 05:20 AM

Thanks a lot. That's perfect. I really appreciate the help.

**TMS** · 02-07-2012, 05:22 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save