| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a column of positive numbers to negitive numbers | Excel Worksheet Functions | |||
| Coloring cells based on positive or negitive numbers | Excel Discussion (Misc queries) | |||
| adding cells with positive and negitive nos. | New Users to Excel | |||
| How do I change numbers from positive to negitive | Excel Worksheet Functions | |||
| Making a cell Negitive only | Excel Discussion (Misc queries) | |||
Linear Mode
