Episode # 155 - Calculate Sales Over Quota
Wednesday, December 28, 2005
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.
You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 3 minutes to learn this lesson now with our free video!
Tags/Keywords for this video: Formulas
More Excel Video Lessons
If you like this video, there are hundreds of 2-5 minute videos available here:
- Excel training videos about Charts
- Excel training videos about VBA
- Excel training videos about Pivot Tables
- Excel training videos about Data Analysis
- Excel training videos about Formulas
- Excel training videos about Formatting
- Excel training videos about Printing
- Excel training videos about Excel 2007
- Excel Video Lessons Index
