Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This is really a basic math question but I thought Excel was the Math Wizard
(more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
income and profit/loss as a percentage | New Users to Excel | |||
format of profit & loss a/c | Charts and Charting in Excel | |||
Profit and Loss Formula | Excel Worksheet Functions | |||
Calculating Profit and Loss in one column | Excel Discussion (Misc queries) | |||
Calculating Profit and Loss in one column | Excel Worksheet Functions |