Formulas Tutorial In Google Sheets

Steps to formulas tutorial in Google Sheets

Option 1: ADD FORMULA

• Step 1: Select the cell where you want to display the result.
• Step 2: Type "=" (select the values you want to calculate, add "+" between the values)
• Step 3: Click "Enter" to see the final result.

Option 2: SUBTRACT FORMULA

• Step 1: Type "=" (select the values you want to calculate, add "-" between the values)
• Step 2: Click "Enter" to see the final result.

Option 3: MULTIPLY FORMULA

• Step 1: Type "=" (select the values you want to calculate, add "*" between the values)
• Step 2: Click "Enter" to see the final result.

Option 4: DIVIDE FORMULA

• Step 1: Type "=" (select the values you want to calculate, add "/" between the values)
• Step 2: Click "Enter" to see the final result.

Option 5: BRING THEM TOGETHER

• Step 1: Type "=" (select all the available values) / by the number you want.
• Step 2: Click "Enter" to see the final result.

Example: "= (A3 + B3 + C3 + D3 + E3) / 100"

Option 6: MIN AND MAX
To find the minimum value:

• Step 1: Type "=MIN" (select all the available values)
• Step 2: Click "Enter"

To find the maximum value:

• Step 1: Type "=MAX" (select all the available values)
• Step 2: Click "Enter"

Option 7: MEAN, MEDIAN, MODE
To calculate the mean:

• Step 1: Type "=AVERAGE" (select all the available values)
• Step 2: Click "Enter"

To find the median:

• Step 1: Type "=MEDIAN" (select all the available values)
• Step 2: Click "Enter"

To find the mode:

• Step 1: Type "=MODE" (select all the available values)
• Step 2: Click "Enter"

Option 8: SUM

• Step 1: Type "=SUM" (select all the available values)
• Step 2: Click "Enter"

For the SUMIF function:

• Step 1: Type "=SUMIF" (select the name of the values, "choose a condition you want", select all the available values)
• Step 2: Click "Enter"

  Example: "=SUMIF(A2:A15, “Chocolate Chip”, B2:B15)"

Option 9: COUNT
To count numbers:

• Step 1: Type "=COUNT" (select all the available values)
• Step 2: Click "Enter" to see the final result.

To use COUNTA (count non-empty cells):

• Step 1: Type "=COUNTA" (select all the available values)
• Step 2: Click "Enter" to see the final result.

To use COUNTIF with condition:

• Step 1: Type "=COUNTIF" (select all the available values, "the value you want to compare")
• Step 2: Click "Enter"

Option 10: CONCATENATE

• Step 1: Select the cell where you want to display the result.
• Step 2: Type the formula "=CONCATENATE" (select the values you want to join)
• Step 3: Click "Enter"
• Step 4: If you want a space between two words, just add quotation marks with a comma in between.

          Example: "=CONCATENATE(A3, “ ”, B3)"