Forum Discussion
Excel Formula
Please help, I cannot find this formula for the following: I need the difference between these 2 data points: example -100 to 438, the difference would be a positive 538. 438 to -100, the differe...
The difference in sign comes from the reversal of the position of A1 and B1 in your formula. Whether D_McClure2020 should use =A1-B1 or =B1-A1 depends on the result that they are after.