Multiple formula query

M

Maurice

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.
 
S

smartin

Maurice said:
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.
Click to expand...

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
 
F

Fred Smith

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

Regards,
Fred.
 
Top