Spreadsheet formulas explained, side by side

Math & Rounding Functions

Sums, products, rounding, remainders, powers and roots. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
SUMAdd up numbers or a range of cells✔✔✔✔
PRODUCTMultiply numbers together✔✔≈≈
ROUNDRound a number to a set number of decimals✔✔✔≈
ROUNDUPRound away from zero✔✔✔≈
ROUNDDOWNRound toward zero (truncate)✔✔✔≈
INTRound down to the nearest whole number✔✔✔✔
MODRemainder after division✔✔✔✔
ABSAbsolute value (remove the minus sign)✔✔✔✔
POWERRaise a number to a power✔✔✔✔
SQRTSquare root of a number✔✔✔✔
CEILINGRound up to the nearest multiple✔✔✔≈
FLOORRound down to the nearest multiple✔✔✔≈
LOGLogarithm to any base✔✔✔✔

✔ built-in function   ≈ works with a workaround formula   ✘ not available