Why ABS Function Behavior Appears Different with Direct Formula vs. Cell References
With direct formulas, fixed numbers may produce a negative result, which ABS converts to positive. With cell references, the values (positive or negative) influence the subtraction, potentially resulting in a positive outcome before ABS is applied
