Home MS Excel TutorialExcelTips and Tricks Finding the maximum magnitude

Finding the maximum magnitude

by Easy Excel Tutorials

Finding The Maximum Magnitude

In this Excel tutorial you will teach yourself how to find the largest number whether negative or positive out of a range of values. This is not obvious, but you need just one formula.


Just one function is enough to determine the largest magnitude of a subset of values in Excel’s table. You should use below formula: 




Maximum MagnitudeHere is the explanation of this formula:First check IF the MAXIMUM value in the A1:A100 range is lower than ABSOLUTE of MINIMUM value. IF it is true that means that the maximum magnitude is a MINIMUM number. Otherwise it is a MAXIMUM number. Remember that a maximum magnitude can be negative or positive number.Here is the whole secret about finding the the maximum magnitude using Microsoft Excel application.


You can download the Template here – Download

You may also like