please help

Occasional Visitor

hi how do i insert a formula or funtion that calclates the difference between 2 cells (2 numbers) when the second cell is the largest of the 2 please

1 Reply


Let's say the two cells are A2 and B2.

In another cell, for example C2, enter the formula =B2-A2 and press Tab or Enter.

If you don't know which of the two has the largest value, you can use =ABS(B2-A2) instead.