Train your new powers

Use inputs tried and tested by Sheets gods.

Total Percentage

Get the total average percentage difference of a range.

Sum all of the values in a range.

Create new ranges by grouping values and adding aggregated data columns.

Extract exactly what you need across a range of strings of values.

Match values across ranges and return a corresponding value from another column.

Calculate the percentage difference from one range of values to another.

Remove columns from a range.

Filter the range using any column of data.

Use IF statements across a full range of data.

Average all of the values in a range.

FOR EXAMPLE / EG

Use FOR EXAMPLE or EG. in your commands to show Formula God an example of what you want.
CLEAN

Adding CLEAN to your command will remove spaces, indents and generally fix formatting issues
Describing Data

If your data is comma-separated in the cell, tell Formula God it is comma-seperated in your command.
TRIM

Adding TRIM to your command will remove space, indents and fix general formatting issues.
IF

You can give formula god commands like any other IF statement: IF this, do that.
RETURN

Use RETURN at the start of your command, followed by your prompt.
CALCULATE

Run calculations on a range of data. Input: "[sum/average/count] the values."
-H

Add -H to the start of your command to ignore headers. Warning: this will remove Formula God's ability to gain context from your data.
APPEND

Adding APPEND to your command will insert a value into the cell. E.g. append column A with ‘hello’, this will add hello to each item in column A
TRANSFORM

Transform or extract values or strings in range. Input: "Extract the [x] from the [y]" "Transform to lowercase" "Replace [x] with [y] in the [string/value/type]" "Split the [x] by [y]"
QUERY

Query ranges and return the data you want. Input: "return the range where column [x] = [y]" "return the range where column [x] = [y] and sort by column [x] alphabetically" "return the range but return column [x] by [transforming it in some way]"