Loading page...
Loading page...
Core formulas that build spreadsheet confidence.
Adds numbers together across a range or multiple ranges.
Calculates the arithmetic mean for a list of values.
A easy counting formula for numeric cells only, useful when blanks and text should not be part of the result.
A easy counting formula for non-empty cells when you need to know how many entries were filled in.
A easy comparison formula for finding the highest value in a range, such as the best score or top price.
A easy comparison formula for finding the lowest value in a range, such as the smallest score or cheapest price.
Returns one value when a condition is true and another when it is false.
A easy logic formula for situations where every condition must be true before the result is accepted.
A easy logic formula for situations where any one of several conditions can make the result true.
A easy logic formula that reverses a TRUE/FALSE result when you need the opposite condition.
Returns the current date and updates automatically.
A easy date formula for deadlines, schedules, and reporting timelines.
A easy precision formula for rounding values to a chosen number of digits without always forcing the result up or down.
A easy rounding formula that always moves a value upward to the precision you choose.
A easy rounding formula that always moves a value downward to the precision you choose.
A easy numeric formula for measuring distance from zero without caring whether the value is positive or negative.
Joins text together from multiple cells or values.
An older easy text formula for joining multiple pieces of text into one result.
A easy text formula for combining many values with a separator and optional empty-cell handling.
A easy text formula for pulling characters from the left side of a string.
A easy text formula for pulling characters from the right side of a string.
A easy text formula for pulling characters from the middle of a string.
A easy text formula for counting how many characters are in a string.
A easy cleanup formula for removing extra spaces from text.
A easy text formula for converting letters to uppercase.
A easy text formula for converting letters to lowercase.
A easy text formula for turning words into title case style capitalization.
Formats values as text with a custom appearance.
A easy conversion formula for turning text that looks like a number into a real numeric value.
A easy text formula for swapping a specific section of text with new content.
A easy text formula for replacing matching text inside a string wherever it appears.
A easy text formula for locating the position of a specific character or word with exact matching.
A easy text formula for locating text without worrying about letter case.