Lesson 32 · Math & Ranking

MEDIAN, MOD, ABS & More Math

Practice MEDIAN, PRODUCT, INT, ABS, MOD, POWER and SQRT in Google Sheets with practical, real-world exercises.

Task 1 of 7

One mansion skews the average sale price. Find the median price instead. Answer in D2.

Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.

The rest of the math toolbox

Function	Use it to…
`MEDIAN`	find the middle value, which isn't skewed by a few huge outliers the way AVERAGE is
`PRODUCT`	multiply a list of numbers together
`INT`	drop the decimals, always rounding down (so negatives go further from zero)
`ABS`	get the size of a difference, ignoring whether it's positive or negative
`MOD`	get the remainder after division, e.g. leftover minutes or every-other-row patterns
`POWER`	raise to a power. Same as `^`, handy for compound growth
`SQRT`	take a square root

A classic combination: INT(A2/60) gives whole hours and MOD(A2, 60) gives the minutes left over.