In this Excel video lesson, we will learn How to combine multiple Excel Functions.
We gonna se how to Combine Formulas and Functions Within the Same Cell in the Excel spreadsheet.

When we use a formula within a formula, or to use a function within a function, we can call it nested function in Excel.

For this free Excel tutorial to be very complete and step by step, I'm going to use a real and practical example of everyday life where I need to calculate each salesperson's commission from their sales.

But in addition to seeing how to calculate the commission rate, I will need to add a bonus for the seller if the average of his sales in the last four months is greater than 75 thousand reais.

For this, we will use several formulas and functions in Excel to help us automate this task.

The IF Function in Excel is one of the main functions in Excel. It serves to make logical comparisons between criteria and conditions in the Excel worksheet. For example, if the seller's sales amount reaches the target, then return to me the text target achieved. However, if the goal is not reached, return to me the phrase goal not achieved.

In this way, we can see that the if function is one of the best functions in Excel to automate repetitive tasks and to automate boring processes quickly and thus we can save time with Excel.

The Average Function in Excel is one of the core basic math functions in Excel.

We can use the average function in Excel through a formula, that is, adding all the cells and then dividing by the number of cells that we have selected, in this way, we will be able to have the arithmetic average of that selected range.

But a more efficient way to use the average function in Excel, as its name suggests, is using a function. In this way, we only need to select the range of cells where we want to take the average of these Excel values and then the average function already returns the arithmetic mean value of these selected cells.

Major Logical Operator. In Excel there are several logical operators such as, lesser, greater, equal, greater equal, lesser equal etc., however, in this practical example, we will use the logical operator Greater to see if the seller's sale is greater than the expected value and, this way, we can calculate the commission and know whether we need to add the bonus to the final commission amount or not.

Sum Formula in Excel serves to sum values as well as the sum function.

The difference between the sum formula and the sum function is that with the sum formula we need to select all Excel cells separately and add the plus sign between them. Now with the Sum function, we only need to select the range.

Multiplication Formula serves so that we can multiply values in Excel. I just need to select the cell I want to use as the first multiplication number and then use the asterisk to separate the multiplication values. I can select as many values as I want and separate them by the asterisk or star symbol.

After we learned how to use all these important functions and formulas in Excel, it is also very important to learn how to combine formulas and functions in Excel, that is, how to combine formulas and functions within the same cell. So, basically, we're going to combine several functions and formulas together in Excel to solve a problem.