Quote:
Imperator Fyron said:
You can overwrite the /4 formula with a 0 for that month.
|
That would leave you with only 3/4ths of your bills paid.
Why not make a row in which you fill in the number of days (or weeks) that month the person was present.
The the divide by 4 becomes:
divide by sum(Presence row), times presence cell for that person.
If the person was there for 2 weeks, while the other three were there for 4 weeks, then the 2-weeker pays 2/14ths of the bill.
If you don't want to measure weeks, and only months, that works too. As long as you ALL don't leave, resulting in a division by zero-people-to-pay-up