“Excel is the best tool non programmers have in order to write code, that’s why it wins.” — antirez on HackerNews

Nothing puts a shiver down a new Excel user’s back like conditional formulas. In this unit we will take our time and explain conditional formulas, the IF, SUMIF, AVERAGEIF, and COUNTIF in a easy to understand way. Before we are done with this unit you will be able to use, with confidence, these powerful tools that scare so many. 

Unit Objectives: 

• Describe and use the IF function to perform a basic logical operation
• List the proper structure of a nested IF function
• Describe and use the SUMIF function to perform a basic logical operation
• Describe and use the AVERAGEIF function to perform a basic logical operation
• Describe and use the COUNTIF function to perform a basic logical operation