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

**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

### 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

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()