Through his post we look at the most important Advanced Excel Formulas, Functions with their application. For instance, you could sum up the values above and below a specific cell using the following formula: Excel has its immense purposeful applications. If your cell is at the center of the column, you can use a combination of positional arguments. You can use positional arguments with the following functions:ДЇor instance, we could calculate the average sales for the above example using the formula:

You can use a keyboard shortcut, click a button and even use a formula to show. For instance, if you have 20 or more columns in your table, you could use the formula =SUM(ABOVE) instead of referencing each cell inside the parenthesis. You can easily show or hide formulas in a number of ways in Microsoft Excel. Argument: P: is the principal amount invested. Positional arguments (ABOVE, BELOW, LEFT, RIGHT) can often make things simpler, especially if your table is relatively large. A user can calculate the future value of the investment using the below formula in excel.

Excel formulas