Skip to content

Four Simple Math Functions

This article will cover four simple math functions you don’t hear about too often.

These functions are simple and easy to use, and we will show you how to use them. The four math functions covered are:

  • MIN
  • MAX
  • ABS
  • SQRT

Now, if you’re ready, let’s dive right in.

The MIN Function

The MIN function finds and returns the minimum value among a list of numbers. For example, let’s say you have the following set of numbers.

  • 2
  • 4
  • 6
  • 8

If you were to use the MIN function on this list, it would return a value of 2 because this is the smallest value in the list.

How to Use the MIN Function

The MIN function requires at least one argument. The argument(s) for the MIN function can be individual numbers or references to cells or ranges containing numbers.

The MIN function will look at each number within each range and return the smallest one.

Check out the example shown below.

The MAX Function

The MAX function finds and returns the maximum value among a list of numbers. For example, let’s say you have the following set of numbers.

  • 2
  • 4
  • 6
  • 8

If you were to use the MAX function on this list, it would return a value of 8 because this is the largest value in the list.

How to Use the MAX Function

The MAX function requires at least one argument. The argument(s) for the MAX function can be individual numbers or references to cells or ranges containing numbers.

The MAX function will look at each number within each range and return the largest one.

Check out the example shown below.

The ABS Function

The ABS function returns the absolute value of any number.

Now, what is the absolute value? Mathematically speaking, it is the distance any number is from zero. Simply speaking, it is the positive variation of any number.

So the absolute value of eight is 8, and the absolute value of negative eight is also 8.

How to Use the ABS Function

The ABS function requires exactly one argument. This argument can be any number. This argument can also be any reference to a cell that contains a number.

Either way, the function will return the absolute value of whatever number it finds.

The SQRT Function

The SQRT function returns the square root value of any number.

Now, what is the square root of a number? Mathematically speaking, it is the value that gives the number when it is multiplied by itself.

What does that mean? It is best understood through an example.

The number four multiplied by itself (four) is equal to 16. Therefore, the number four is the square root of the number 16.

And what is the square root of the number four? The square root of the number four is two. This is because two multiplied by itself (two) is equal to four.

How to Use the SQRT Function

The SQRT function requires exactly one argument. This argument can be any number. This argument can also be any reference to a cell that contains a number.

Either way, the function will return the square root of whatever number it finds. Take a look at the two examples shown below.

And that sums up the four math functions for the day. Be sure to leave a comment down below if you have any questions.

Also, let us know if you would like to see an article written on any functions or formulas we haven’t yet covered.

This Post Has 2 Comments

  1. I use ABS all the time! It is so helpful!

    As far as other functions or formulas, would you consider doing one on XLOOKUP? I know it’s kind of new, so I would love the expert view on it!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top