In this Excel tutorial lesson, you will learn how to find the largest number, whether negative or positive, in a range of values. This is not obvious, but you need just one formula.
Formula to find a magnitude
Just one function is enough to determine the largest magnitude of a subset of values in Excel's table. You should use the below formula:
An example of how to find the largest number
Here 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 the maximum magnitude can be a negative or positive number.
Here is the whole secret of finding the maximum magnitude using the Microsoft Excel application.