Question

Can we include function while creating a formula in excel

Answer 1

Yes, function can be included while creating a formula in Excel.

A formula is any calculation in Excel. A function is a pre-defined calculation.

An example of a formula containing a function is:

=MAX(A1:B20)

To use functions in Excel:

1. Enter an equal sign (=)

2. Click the appropriate tab from the library containing the function you want to use

Excel will insert the selected function into the formula box with parenthesis and open the 'Function Arguments' dialog box.

3. Enter the argument or select the cells or range of cells to get the answer.