Creating Formulas and Functions

Multiply H3 times C4

• =H3xC4

• H3XC4

• H3*C4

• =H3*C4

Add C2 and C3

• C2+C3

• C3+C2

• =C2+C3

• =SUM(C2+C3)

Subtract D4 from D3

• =D4-D3

• =D3-D4

• =SUBTRACT(D4-D3)

• D3-D4

Divide E3 by C1

• =C1/E3

• =E3/C1

Add the range B2-B10

• =B2+B10

• =SUM(B2,B10)

• =SUM(B2-B10)

• =SUM(B2:B10)

Add C6 through C10 then subtract C5

• =SUM(C6:C10)-C5

• =C6+C7+C8+C9+C10-C5

• =SUM(C6-C10)/C5

Add A3 and A4 then divide by C10

• =A3+A4/C10

• =(A3+A4)/C10

• =C10/A3+A4

• =C10/(A3+A4)

Find the average of D1 through D10

• =AVERAGE(D1:D10)

• =AVERAGE(D1-D10)

• =AVERAGE(D1,D10)

• =AVERAGE(D1;D10)

Find the net income of the income amounts that are located in B2 through B4 and the expenses that are in B7 through B12.

• =SUM(B2:B4)+SUM(B7:B12)

• =(B2:B4)+(B7:B12)

• =B2+B3+B4+B8+B9+B10+B11+B12

• =SUM(B2:B12)

Find the sales tax if Total Sale amount is in E12 and tax rate is in B4

• =E12*B4

• =E12XB4

• =E12/B4

• =SUM(E12*B4)