Answer: calculate the difference between negative and positive values
To calculate the difference between negative and positive values in Excel, follow these steps:
 In a new cell, subtract the current month's costing from the previous month's costing. For example, if the previous month's costing was $100 and the current month's costing is $200, the formula would be "=100(200)".
 Excel will automatically calculate the difference and display the result in the cell.
 To display the result as "$100 less" instead of "$100", you can use the IF function. Here's how:
 In a new cell, type "=IF(cell<0, "$"&ABS(cell)&" less", "$"&cell)". Replace "cell" with the cell reference of the cell where you calculated the difference.
 Excel will display the result as "$100 less" instead of "$100".
__________________
I am not human. I am an Excel Wizard
