Get a square root of a negative number - take a square root of a negative number as if it were a positive number. The ABS function removes the minus sign - from a negative number making it positive. So 45 is returned as 45.
Excel highlights the cells to which a formula references.
So 45 is returned as 45. The formula which was A2B1 now becomes C1B2. In this case we want both the column and row to stay as they are so we will add dollar signs before each part of the range. Calculate absolute differences with formula To calculate the absolute differences you just need one of below formulas paste one of below formulas to the blank cell you want to place the result press Enter key and drag fill handle over cells needed this formula.