Multiple formula query
 

I share utilities and have a spreadsheet that divides each bill by four, adds
the column for my total. There are times when a credit appears. I would
want each cell to take that into account as well so that overpayment is
divided by four and subtracted from the total. Is there a way for a cell to
take either circumstance into account and calculate the appropriate value?
Guidance sought.

Multiple formula query
 

Maurice wrote:
I share utilities and have a spreadsheet that divides each bill by four, adds
the column for my total. There are times when a credit appears. I would
want each cell to take that into account as well so that overpayment is
divided by four and subtracted from the total. Is there a way for a cell to
take either circumstance into account and calculate the appropriate value?
Guidance sought.

Not sure how you have this laid out but here's the general idea.

I assume you show both bills and credits as positive numbers, since you
say you want to subtract the credits.

So to calculate each person's liability you take

=(SUM(cells with bills) - SUM(cells with credits))/4

Multiple formula query
 

Just enter the credit as a negative number. Then it will add up properly.

Regards,
Fred.

"Maurice" wrote in message
...
I share utilities and have a spreadsheet that divides each bill by four,
adds
the column for my total. There are times when a credit appears. I would
want each cell to take that into account as well so that overpayment is
divided by four and subtracted from the total. Is there a way for a cell
to
take either circumstance into account and calculate the appropriate value?
Guidance sought.