EXCEL SYNTAX
 Select formula type: Excel (default) or Python formulas

Type a formula, starting with the equal sign
=
You must type a formula by using values displayed in the first row.
For example:
✅=A1+B1
✅=SUM(A1:B1)
Not:❌=A1+A6
❌=SUM(A:B)
❌=SUM(A1:A10)
Apply your formula to all rows (default)
Select Apply to all rows
in order to apply the same formula to the entire column.
Supported Formulas (Need more? Send use a quick word 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 uppercase or lowercase 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
ADD SPECIFIED TEXT TO THE BEGINNING OR END OF CELL
="Text"&A1
to add text at the beginning="A1 & "Text"
to add text at the end of the cell
This function is similar to Concatenate, but lets you specify the text you want to insert.
Example: In the table below, we want to insert https://twitter.com/
to all values in the the column B
in order to get complete URLs.
Solution:

Add the step
Formula
and type in="https://twitter.com/"&B1
to concatenatehttps://twitter.com/
to the value inb1
.  Make sure that
Apply to all rows
is checked.
PYTHON SYNTAX
 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()