Material Detail

“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 an 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

This will delete the comment from the database. This operation is not reversible. Are you sure you want to do it?

Thank you for reporting a broken "Go to Material" link in MERLOT to help us maintain a collection of valuable learning materials.

If you feel this material is inappropriate for the MERLOT Collection, please click SEND REPORT, and the MERLOT Team will investigate. Thank you!

You are being taken to the material on another site. This will open a new window.

Do not show me this again