For instance, if you have a profit loss of -500, to get the absolute value, you would type: =ABS(-500) The function will return 500, disregarding the negative sign.

The profit-and-loss statement example from ATBS that follows includes valuable operating information ... (Microsoft Excel, Google Spreadsheets) became more widely available, ...

A profit and loss statement summarizes a company's revenues and expenses during a given time period. Learn why this is important for your portfolio. S&P 500 +---% | Stock Advisor +---% ...