Episode 155 - Calculate Sales Over Quota

An introduction to using the IF function to change the calculation based on a condition in your data. Today's podcast shows how to use the IF function to calculate sales in excess of quota. The podcast also shows a slightly less-intuitive, but faster version of the formula using the MAX function. Watch Episode 155 for all of the details.

This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!