How to tell excel to do the "absolute" subtraction?

[logi_non_tech]

I have three cells, all are numbers: Cell A1, Cell A2, and Cell A3.

In cell A1 and A2 I can put a value from 0 to 10.

I need to tell excel to subtract the bigger form the smaller and put the result in cell A3

If cell A1 is 8 and cell A2 is 4, excel should do: A1-A2 = 4

But

If cell A1 is 8 and cell A2 is 10 excel should do A2-A1 = 2

How do I do that?

[logi_non_tech]

Is it correct to do something like?

IF(A1>=A2, A1-A2, A2-A1)

[MrShorty]

That would be correct. One could also use MAX(range)-MIN(range), but I think what you are really asking for is the ABS() function: https://support.office.com/en-us/art...a-c99d7c87713c

[logi_non_tech]

Great, thanks!

[Bo_Ry]

Or =ABS(A1-B1)