offers Excel lesson videos made simple!

Sign up or log in to Magoosh Excel.

12 Excel Equations You Absolutely Must Learn

excel equations -magoosh

As one of the best data crunching tools in the market, Microsoft Excel is also one of easiest to learn due to its clean user interface and a variety of prebuilt options meant to provide convenience to a user to crunch data. Excel equations are one of the options available in the excel tool.

Excel equations are very handy prebuilt formulas in excel. You can easily find formulas for most of the basic operations. Once you go through this article, you will easily understand the basic excel equations and how to use it to get the desired result.

1. SUM(number 1, number 2, ..)

This excel equation takes the range of numbers and provides the summation of all the numbers.

E.g. If you want to know the sum of 1, 2, and 3, you can use the formula as follows:

=SUM(1,2,3) Output 6

Note: You can also give cell range e.g. A1: A3 instead of numbers.

2. AVERAGE(number 1, number 2, ..)

This excel equation takes the range of numbers and gives the average of all the numbers.

E.g. If you want to know the average of 1, 2 and 3, you can use the formula as follows:

=AVERAGE(1,2,3) Output 2

3. MAX(number 1, number 2, ..)

This excel equation returns the largest value among all the arguments.

E.g. If you want to know the max of 1, 2, and 3, you can use the formula as follows:

=MAX(1,2,3) Output 3

4. MIN(number 1, number 2, ..)

This excel equation returns the smallest value among all the arguments.

E.g. If you want to know the max of 1 2 and 3, you can use the formula as follows:

=MIN(1,2,3) Output 1

5. COUNT(range of cells)

This excel equation counts the number of cells that contain the number. It ignores blank and empty cells.

E.g. If A1=1, A2=3, A3=”ABC”, A4=”def”, A5=”xyz” then =COUNT(A1: A5) will be 2.

6. COUNTA(range of cells)

This excel equation count the number of cells that are not empty.

E.g. If A1=, A2=3, A3=”ABC”, A4=”def”, A5=”xyz”, then =COUNTA(A1: A5) will be 4.

Check out my COUNTA post for or more examples of how to use this function.

7. TODAY()

This equation is part of Date & Time Excel equations as it gives the output for the present day’s date.

E.g. If today’s date is 4/17/2018 then =TODAY() will return 4/17/2018.

8. NOW()

This equation returns the today’s date as well as current time.

E.g. If today’s date is 4/17/2018 and the current time is 4:00 PM, it will return 4/17/2018 16:00.

9. RAND()

This excel equation returns a randomly generated number between 0 and 1 (and changes each time when you refresh)

E.g. =RAND() (Potential) Output .2232

10. RANDBETWEEN(lower number, upper number)

This excel equation gives you the randomly generated number which falls between the specified numbers.

E.g. =RANDBETWEEN(1,100) (Potential) Output 63

11. COUNTIF(range, criteria)

This excel equation count the number of cells which meets the given criteria.

12. COUNTIFS(range 1, criteria 1, range 2, criteria 2)

This excel equation works same as COUNTIF but it allows multiple criteria.

Check out my post on the logic behind COUNTIF and COUNTIFS for more examples of how to use these functions.

These are some very basic formulas and you will easily remember just by practicing a few times with some data. Note that you don’t have to remember the exact syntax. Excel will provide you the suggestion once you start typing.

Happy working with Excel!

Comments are closed.


Magoosh blog comment policy: To create the best experience for our readers, we will only approve comments that are relevant to the article, general enough to be helpful to other students, concise, and well-written! 😄 Due to the high volume of comments across all of our blogs, we cannot promise that all comments will receive responses from our instructors.

We highly encourage students to help each other out and respond to other students' comments if you can!

If you are a Premium Magoosh student and would like more personalized service from our instructors, you can use the Help tab on the Magoosh dashboard. Thanks!