Excel Function : Ignore Positive/Negative Number with ABS()
Number Absolute Value 80 80 =ABS(C4) -10.25 10.25 =ABS(C5) 36.25 36.25 =ABS(C6) 23.64 23.64 =ABS(C7) What Does it Do ? This function calculates the value of a number, irrespective of whether it is positive or negative. Syntax =ABS(CellAddress or Number)…