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

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?

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

• Then why do you use ABS()? – Oleg_S Mar 17 at 11:24
• To add to @Oleg_S point - ABS is a function which takes the ABSolute value of a number, throwing away the sign. You probably just need =A1-A2 with no functions at all. – AdamV Mar 17 at 12:27

You said `ABS(A1-A2)`
To find the difference, just do `A1-A2`