About Excel Formulas

Excel Formulas by ShareYourGroup explains the functions of Microsoft Excel in plain words: 52 pages covering 87 functions, each with its syntax, worked examples and the mistakes people make, plus 9 guides on writing formulas.

Where the content comes from

Every explanation and example is our own writing. The sample sheets (marks, sales, a price list and others) are made up. Every example result on the site was calculated in Microsoft Excel itself (version 16.0, build 20326) on 12 November 2026: a script puts the sample sheet and the formula into Excel and records what Excel shows. No result is typed by hand.

The final word on any function is Microsoft's own documentation at support.microsoft.com. Notes on which Excel versions have a function, and on how Google Sheets differs, are written from general knowledge and were not all tested; check them on your own version.

An independent site

This is an independent help site. It is not connected with or approved by Microsoft. Excel and Microsoft 365 are trademarks of Microsoft Corporation, named here only to say which program a formula is for. The people and figures in the sample sheets are made up.

Who makes it

This site is part of ShareYourGroup, a family of free sites about the things people share, send and do together. It is free to use and needs no login. Advertisements pay for the hosting and the work.

Found a mistake?

Please tell us the page and what is wrong. We check and fix it.