Formulas

Formulas used in Excel

The most common formulas are the ones used in sum, average, multiplication, division, and calculating percentages.

Sum

To perfom this task you need to enter this formula: =SUM(B3:B22)

Average

To accomplish this task you need to enter this formula: =AVERAGE(E3:I3:M3:Q3:U3)

Multiplication

To fulfill this task you need to enter the following formula: = (D2*E2)

Dividing

For carrying out this task you need to enter this formula: = (D5 /C5) 

Calculating percentages

For performing this task you need to enter this formula: = (D4 /C4) *100