Jul 18 2021 04:01 AM
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
Jul 18 2021 04:03 AM
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.