**Finding The Maximum Magnitude**

**=IF(MAX(A1:A100)<ABS(MIN(A1:A100));MIN(A1:A100);MAX(A1:A100))**

**Template**

You can download the Template here – Download

Further reading: Basic concepts Getting started with Excel Cell References