Level 133 formulas

Foundations

Core formulas that build spreadsheet confidence.

SUM

→

Adds numbers together across a range or multiple ranges.

=SUM(number1, number2, ...)

AVERAGE

→

Calculates the arithmetic mean for a list of values.

=AVERAGE(number1, number2, ...)

COUNT

→

COUNT is a easy formula used in professional spreadsheet workflows.

=COUNT(...)

COUNTA

→

COUNTA is a easy formula used in professional spreadsheet workflows.

=COUNTA(...)

MAX

→

MAX is a easy formula used in professional spreadsheet workflows.

=MAX(...)

MIN

→

MIN is a easy formula used in professional spreadsheet workflows.

=MIN(...)

IF

→

Returns one value when a condition is true and another when it is false.

=IF(logical_test, value_if_true, value_if_false)

AND

→

AND is a easy formula used in professional spreadsheet workflows.

=AND(...)

OR

→

OR is a easy formula used in professional spreadsheet workflows.

=OR(...)

NOT

→

NOT is a easy formula used in professional spreadsheet workflows.

=NOT(...)

TODAY

→

Returns the current date and updates automatically.

=TODAY()

NOW

→

NOW is a easy formula used in professional spreadsheet workflows.

=NOW(...)

ROUND

→

ROUND is a easy formula used in professional spreadsheet workflows.

=ROUND(...)

ROUNDUP

→

ROUNDUP is a easy formula used in professional spreadsheet workflows.

=ROUNDUP(...)

ROUNDDOWN

→

ROUNDDOWN is a easy formula used in professional spreadsheet workflows.

=ROUNDDOWN(...)

ABS

→

ABS is a easy formula used in professional spreadsheet workflows.

=ABS(...)

CONCAT

→

Joins text together from multiple cells or values.

=CONCAT(text1, [text2], ...)

CONCATENATE

→

CONCATENATE is a easy formula used in professional spreadsheet workflows.

=CONCATENATE(...)

TEXTJOIN

→

TEXTJOIN is a easy formula used in professional spreadsheet workflows.

=TEXTJOIN(...)

LEFT

→

LEFT is a easy formula used in professional spreadsheet workflows.

=LEFT(...)

RIGHT

→

RIGHT is a easy formula used in professional spreadsheet workflows.

=RIGHT(...)

MID

→

MID is a easy formula used in professional spreadsheet workflows.

=MID(...)

LEN

→

LEN is a easy formula used in professional spreadsheet workflows.

=LEN(...)

TRIM

→

TRIM is a easy formula used in professional spreadsheet workflows.

=TRIM(...)

UPPER

→

UPPER is a easy formula used in professional spreadsheet workflows.

=UPPER(...)

LOWER

→

LOWER is a easy formula used in professional spreadsheet workflows.

=LOWER(...)

PROPER

→

PROPER is a easy formula used in professional spreadsheet workflows.

=PROPER(...)

TEXT

→

Formats values as text with a custom appearance.

=TEXT(value, format_text)

VALUE

→

VALUE is a easy formula used in professional spreadsheet workflows.

=VALUE(...)

REPLACE

→

REPLACE is a easy formula used in professional spreadsheet workflows.

=REPLACE(...)

SUBSTITUTE

→

SUBSTITUTE is a easy formula used in professional spreadsheet workflows.

=SUBSTITUTE(...)

FIND

→

FIND is a easy formula used in professional spreadsheet workflows.

=FIND(...)

SEARCH

→

SEARCH is a easy formula used in professional spreadsheet workflows.

=SEARCH(...)

Loading page...