The ABS function will automatically change any negative results into positive values, giving you only absolute differences. Method 3: Using IF Formula for Conditional Calculation In situations where ...