Get Microsoft Excel to do profits and losses to create an electronic balance sheet. Excel allows you to perform a range of calculations using simple formulas, including figuring a running balance ...

Mastering the ABS Function in Excel The ABS function is especially handy in scenarios where you need to measure total changes or impacts without distinguishing between gains and losses.

How to calculate Simply put, an unrealized gain or loss is the difference between an investment's value now, and its value at a certain point in the past.