Featured Formulas

Lookup

Quantity based discount

One way to set up a quantity-based discount formula is to place the discounted items in a lookup table, then perform a two-way lookup. In the example shown, the formula in E5 is: =XLOOKUP(B5,item,XLOOKUP(C5,quantity,discount,0,-1),0) Where item …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

VSTACK Function

The Excel VSTACK function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array.Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Whenever I need support in Excel, I search in Google. Most of the time I get a complete solution from the Exceljet. Your efforts are appreciated highly for making excel related solutions easy to understand.
Shabbir
Your site is GREAT and so refreshing compared to the rest of the stuff out there on Excel. The writing and explanations are clear, concise, and to the point!
Jeff
Love your website. Your algorithms are clever and innovative. Your examples are easy to follow. And I've never seen a cleaner looking website. It has been extremely helpful to me.
I've never seen a cleaner looking website
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