## EXCEL SYNTAX

1. Select formula type: Excel (default) or Python formulas
2. 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.

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".

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.

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 concatenate `https://twitter.com/` to the value in `b1`
• Make sure that `Apply to all rows`  is checked. ## PYTHON SYNTAX

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

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