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