Featured Formulas

Featured Functions

IFERROR Function

The IFERROR function returns a custom result when a formula returns an error and a normal result when a formula calculates without an error. The typical syntax for the IFERROR function looks like this:

=IFERROR(formula,custom)...Read more

Recent Articles

I've recently begun to learn to really exploit some of the real power of Excel and I find your Exceljet site is the easiest of all I've seen to navigate and understand. Your explanations are clear and concise with very good samples. And I love the way you have the "Excel Formulas" section of your site set up. It is so easy to look up the formula you need information on. And furthermore, if unsure of what strategy to use to accomplish your goal all your formula pages have links to other similar things to try. Its been a great resource for me. Thank you so much!
Scott
I really appreciate your efforts, the site basically has everything we need, i've started recently working as a Quantity Surveyor, and Excel is very important in such kind of work.
Amina
Just a quick note to say thank you for your valuable website. I am a casual user of Excel and appreciate being able to use the suggestions you offer to simplify my sheets. I have used a number of your examples to manipulate data for personal record keeping. THANK YOU!
Robin

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages