Formulae

• Microsoft Excel gives users the flexibility to configure data and perform very basic operations, such as addition, subtraction, multiplication, or division by using shortcuts or custom formulas.
• These are the basic Excel formulas we are using:
• SUM
• AVERAGE
• MAX
• MINI
• COUNT
• IF

Sum

• The SUM function is the most widely used function in Microsoft Excel. Functions are predefined formulas that are built-in to Microsoft Excel to make your life easier.
• Syntax: SUM(number1,[number2],...).
• Example: SUM(D2:D10).

• Press Enter.

AVERAGE

• This formula used to calculate the average value.
• Syntax: AVERAGE(number1,[number2],...).
• Example: AVERAGE(D2:D10).

• Press Enter.

MAX

• This formula used to calculate the maximum value.
• Syntax: MAX(number1,[number2],...).
• Example: MAX(D2:D10).

• Press Enter.

MIN

• This formula used to calculate the minimum value.
• Syntax: MIN(number1,[number2],...).
• Example: MIN(D2:D10).

• Press Enter.

COUNT

• This formula used to calculate the count value of the number of prices.
• Syntax: COUNT(number1,[number2],...).
• Example: COUNT(D2:D10).

• Press Enter.

IF

• The IF function (formula) may be used to apply a condition to your data.
• Syntax: IF(logical_test, value_if_ true, value_if_false).
• Example: =IF(D2>3500,"Stock","In stock").

• Press Enter.