- Select formula type: Excel (default) or Python formulas
- Enter the output column name
- Type a formula, starting with the equal sign
Operation between columns
In order to apply formulas between entire columns, first apply the operation to the first row, for example
=A1+B1 and then check the option Apply to all rows.
Apply to all rows
Select Apply to all rows in order to apply the same formula to the entire table. The formula must only take arguments from the first row, for example: =SUM(A1:B1) , not =(A2:B2) or =(A1:A3)
Below is a list of the most common formulas we currently supported. The entire list is here.
The Excel SUM function returns the sum of values supplied as multiple arguments. SUM can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants. Learn more
Returns the absolute value of a number. The absolute value of a number is the number without its sign. Learn more
Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula
=AVERAGE(A1:A20) returns the average of those numbers. Learn more
The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result.
For example, to "pass" scores above 70:
=IF(A1>70,"Pass","Fail") . More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR. Learn more.
MIN - MAX
The MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values. Learn more
LEFT - RIGHT
=LEFT (text, [num_chars])
=RIGHT (text, [num_chars])
The LEFT and RIGHT functions extract a given number of characters from the left or right side of a supplied text string. For example,
LEFT("apple",3) returns "app".
=MID (text, start_num, num_chars)
The MID function extracts a given number of characters from the middle of a supplied text string. For example,
=MID("apple",2,3) returns "ppl". Learn more
UPPER - LOWER
The UPPER and LOWER functions return a upper-case or lower-case version of a given text string. Numbers and punctuation are not affected.
The TRIM function strips extra spaces from text, leaving only a single space between words and no space characters at the start or end of the text. Learn more
The Excel LEN function returns the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included. Learn more
=REPLACE (old_text, start_num, num_chars, new_text)
The Excel REPLACE function replaces characters specified by location in a given text string with another text string. For example
=REPLACE("XYZ123",4,3,"456") returns "XYZ456" . Learn more
- Type in a formula using the exact column names in your table.
2. Add a column name to store your output
In Python Formulas are expressions, with one variable defined for each column name. You can use mathematical and string handling operations, for example