Featured Formulas

Min and Max

Maximum change

In the example shown, the goal is to calculate the maximum difference between the "High" values in column C and the "Low" values in column D. Because the difference between High and Low is not part of the data, the calculation must occur in the formula itself. This is a classic example of...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Logical

IFS Function

The IFs function evaluates multiple expressions and returns a result that corresponds to the first TRUE result. You can use the IFS function when you want a self-contained formula to test multiple conditions at the same time without nesting...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I just wanted to say a huge THANK YOU to you both for your amazing content. I have been using your site for about 6 months now and you have always had the information I was looking for. I have been able to up my game in Excel and am creating more meaningful reports thanks to you. You are making my work life so much easier!
Duane
My excel savior! I'm so grateful for the existence of this site.*please receive a bow from me*
Franny
This is the absolute best site for solving Excel problems and finding new ways to use Excel! I will sometimes search the web for a problem and I really don't know why I don't just come here first. I waste so much time trying to understand solutions on other sites. Then I come to ExcelJet and get a solution that I understand and BOOM my formula works! Thanks for this site. It is wonderful!!!
Michelle
More Testimonials

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