Featured Formulas

Income tax bracket calculation

In this example, the goal is to calculate the total income tax owed in a progressive tax system with multiple tax brackets, as shown in the worksheet. The article below first reviews how taxes are computed in a progressive system. Next, it shows how to accomplish this task in Excel using...Read more

Featured Functions

STOCKHISTORY Function

The STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The main purpose of STOCKHISTORY is to get the history of a financial instrument over time. Although the name suggests that STOCKHISTORY is meant to work only with stocks,...Read more

Recent Articles

I basically spend all day, every day, in Excel for my work. When I see your website pop up with an answer to my question, I ALWAYS select it first. In fact, I look for exceljet.net option FIRST, hoping your website pops up with a solution for me. I absolutely love the way you explain things. It is easy to follow your instruction and you offer BOTH written instruction as well as video.
LBM
I just wanted to tell you that your site is excellent. I have found so many examples and a great help in my job. Your examples for sumproduct and multiple criteria, index and match with multiple criteria are unbelievable. Congratulations!
Nick
I just wanted to say thank you for this formula =SUMPRODUCT(--ISNUMBER(SEARCH(things,A1)))>0. It has proven to be one of the most useful formulas I have ever used.... especially when you're daily checking a 1.k5+ row list against a 50k row list.
Ben

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