Multiple formula query

  • Thread starter Thread starter Maurice
  • Start date Start date
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.
 
Just enter the credit as a negative number. Then it will add up properly.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula 5
Compare ranges - compute agreement % 4
Excel Sumproduct 0
Formula to calulate the weighted average 4
Divide Cells on a spreadsheet by 1000 3
Autosum data from 2 columns with Divide function 1
If formula 15
disperse amount across multiple cells without fractions 3

Back
Top