Question Google Sheets - Formula to find difference between two values and recognize if the number difference is positive or negative

Jan 10, 2021
8
0
20
1
Hope my blabbering will make sense to someone.

I'm trying to create a spreadsheet in Google Sheets to record profits and losses.

I've used the =ABS(A1-A2) formula to get the differences in between two cells values, but I've noticed that it doesn't recognize negative number differences.

For Example: Cell A1 is $10.00, and cell A2 is $7.50. The difference in that is -$2.50. It does that, but it marks it as '$2.50', not '-$2.50'.

Does anyone know a formula or a way for Google Sheets to recognise whether the value in Cell A2 is lower or higher than the cell in A1, so it will mark it as '-$2.50' instead of '$2.50'?

Any help would be appreciated, have been trying to work this out for an hour!
 

ASK THE COMMUNITY