EXCEL SYNTAX

  1. Select formula type: Excel (default) or Python formulas
  2. Enter the output column name
  3. 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) 

Supported Formulas

Below is a list of the most common formulas we currently supported. The entire list is here.

SUM
=SUM(A,B)
=SUM(A1:D1) =SUM(A1:A8)
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

ABS
Returns the absolute value of a number. The absolute value of a number is the number without its sign. Learn more

AVERAGE
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

IF
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
=MAX(5,10)  =MAX(A1:A10)  =MAX(A1,A2,A3)
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".
Learn more

MID
=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
=UPPER (text)
The UPPER  and LOWER functions return a upper-case or lower-case version of a given text string. Numbers and punctuation are not affected.
Learn more

TRIM
=TRIM (text)
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

LEN
=LEN (text)
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
=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

PYTHON SYNTAX

  1. Type in a formula using the exact column names in your table. 

   2. Add a column name to store your output

Syntax

In Python Formulas are expressions, with one variable defined for each column name. You can use mathematical and string handling operations, for example

math.round(family_units/10)name.strip()
name.strip()

Did this answer your question?