function in excel formula

Many of the formulas you create use available worksheet functions. These functions allow you to greatly enhance the power of formulas and perform calculations that are difficult to compute using only operators. For example, you can use the LOG or SIN functions to calculate log or Sin ratios. Such complex calculations cannot be done using only mathematical operators.

use function

When you type the = sign and then any letter, you will see the function searched as below.

Suppose you need to determine the maximum value in a range. A formula can’t tell you the answer without using a function. We’ll use a formula that uses the MAX function to return the maximum value in the range B3:B8 as =MAX(A1:D100).

Another example of a function. Let’s say you want to find if the month’s cell is greater than 1900, then we can give the sales rep a bonus. We can achieve it by writing a formula with an IF function =IF(B9>1900,”Yes”,”No”)

function parameter

In the examples above, you may have noticed that all the functions use parentheses. The information in parentheses is the parameter list.

Functions differ in how they use parameters. Depending on what it has to do, a function might use.

No arguments – Example – Now(), Date(), etc.

One parameter – UPPER(), LOWER(), etc.

Fixed number of arguments – IF(), MAX(), MIN(), AVERGAGE(), etc.

Unlimited number of parameters

optional parameter

Related: