offers Excel lesson videos made simple!

Sign up or log in to Magoosh Excel.

4 Excel Formulas With Examples

With the increasing complexity of the business world, there is more and more demand for an easier and fast working medium where data stocking, recordings, calculations, and even graphical and statistical studies can be done very fast. As businesses are gradually getting globalised, the need for a proper maintenance has become more prominent, leading to the creation of a platform like Microsoft Excel. Since its time of development, the application has proved to be the most beneficial tool for the businessmen, no matter to which sector they belong or how big their business markets are. The application has been developed and fashioned in a way that everyone can use as per their own convenience; there is no need to have expert knowledge about the application.

Why is Excel a useful tool?

Excel has been known for having many features like statistical formulas, mathematical operations, and even graphical features, which are all preloaded into the Excel’s compiler. These preloaded functions help in calculation and solving complex mathematical problems automatically by only writing the formulas and the cells on which you would like to have the formula applied.

There is an expression for every formula which is written on the bar above the spreadsheet. Multiple formulas can be applied at a time in a single spreadsheet. The only thing that has to be taken care of, is the name of the cells of the rows and the columns upon which the formula will be applied. Even, you can apply a general formula for multiple rows with different sets of values. This is one of the main advantages of the formulas in the Microsoft Excel and that is why, it is even replacing the calculator when it comes to the questioning of calculating on spot.

How to write a formula in Excel?

Formulas can be written in two ways in a spreadsheet; both involve the cells in which you would like to have the calculated value.

In the general case, the formula statement is written in the desired cell and then the enter button is pressed. Once this is done, the calculated value will be automatically updated in the cell, in which you entered the formula statement. Usually, an “equal to” sign precedes the statement, while the statement consists of either the operation name like AUTOSUM, or the operation itself.

In the case of using the library function name, the syntax is as follows:
=AUTOSUM(C3,G7)
This will print the value of the summation of the data present in the C3 cell and the G7 cell.

The other method is to directly write the statement as in:
=C3+G7
This will also generate the result in the selected cell.

In case you want to edit a formula, then you can do that by following these steps:

  1. Select the cell where you want to make the necessary changes.
  2. Once selected, move the cursor to the empty bar at the top of the spreadsheet.
  3. Follow the same syntax of the formula statement and write the new formula which you want to apply.
  4. After that, press the enter key and the newly calculated value will appear in the desired cell.

Some basic Excel formulas along with examples

Here, we have described some of the basic formulas that can be easily implemented in Excel using the basic syntaxes. However, for more modified calculations, these formulas have been made more complex to support the complications of the calculations. Formulas are not only pertaining to the different mathematical operations; rather you can use the stored formulas to do some shifting, printing or generating chart operations.

MOD function

The formula is used to return the remainder of the division of any two numbers written in two different cells. For example, let us consider, A2=8 and A6=64 and A1=9.

So the function can be implemented like:
=MOD(A6,A2)
This is will give 0 as the result since 64 is divisible by 8.

Again, if we consider:
=MOD(A1,A2)
This will give 1 as the result since the remainder of the division is 1.

SUM

The most basic function that finds its use in daily business is SUM. This particular function can calculate the result for 255 numbers of arguments consisting of ranges, arrays, and constants. There is also an option of using the AUTOSUM function, which can generate the summation of a number of cells selected easily.

The format is:
=SUM(…….number 1, number 2,…..)
Or:
=SUM(……A3,A5,A8,…….)

For example,
=SUM(4,2,1)
The value of the calculation will be 9.

AVERAGE

This function is used in both normal conditions and also in cases where the result has to be declared corresponding to certain conditions. In the latter case, however, the function changes to AVERAGEIF.

The format of average library function is:
=AVERAGE(A3: A8)
A3 and A8 can be any arguments.

If we consider A3=8 and A8=10, then the result will be equal to 8. This function is quite useful in calculating the average or an approximate argument’s value.

INDEX

This built-in formula is used to look for the desired value in a table.

For example, in a table bounded by A1 and D100, suppose D56 has a value of 661. We want to know what this value is without scrolling down.

So, we will write the formula as:
=INDEX(A1:D100,56,4)
This will give the result 661 corresponding to row 56 and column 4 of the table.

These were some examples of Excel formulas that are frequently used. Hope you found this post helpful. 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!