spreadsheet with negitive numbers
 

I am running a spreadsheet to show the profit or loss on some projects.
Thankfully most of them are at a profit but there are a few that show a loss.

One colunm shows the total gross loss as a negitive number and from there
the sheet also figures the cost of various taxes (Social Security, Federal,
etc). The the sheet shows the total profit/loss after all expenses including
taxes. Since the first number is a negitive, the taxes show as negitives
also (this is not the problem). The problem is that when the sheet figures
the total after taxes, it subtracts the negitive amounts from the total gross
loss. It should add them to the total gross loss.
How do I make the negitive taxes add to the gross loss?

spreadsheet with negitive numbers
 

Try function ABS()

If this post helps click Yes
---------------
Jacob Skaria


"bbrodsky" wrote:

I am running a spreadsheet to show the profit or loss on some projects.
Thankfully most of them are at a profit but there are a few that show a loss.

One colunm shows the total gross loss as a negitive number and from there
the sheet also figures the cost of various taxes (Social Security, Federal,
etc). The the sheet shows the total profit/loss after all expenses including
taxes. Since the first number is a negitive, the taxes show as negitives
also (this is not the problem). The problem is that when the sheet figures
the total after taxes, it subtracts the negitive amounts from the total gross
loss. It should add them to the total gross loss.
How do I make the negitive taxes add to the gross loss?