Excel Chapter 8: Advanced Logic & Conditional Functions

In this chapter, we revisit mathematical and statistical functions like SUM, AVERAGE, and COUNT from Chapter 2. We will take another look at setting up logical tests based on our studies of Chapter 3. We will touch upon using Excel to evaluate one or more conditions as we have done in Chapter 5 with Excel tables and PivotTables in Chapter 6. We will combine elements from all previous chapters and continue our work with the College Scorecard dataset we introduced in Chapter 6.  In this chapter, we take all our existing knowledge of Excel and combine aspects of functions and formulas to do even more with them.

 


 

Attributions:

Chapter 8 by Emese Felvégi and Robert McCarn.

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Business Computer Information Systems Copyright © 2020 by Emese Felvegi; Barbara Lave; Diane Shingledecker; Julie Romey; Noreen Brown; Mary Schatz; OpenStax; Saylor Academy; University of Minnesota Libraries; and Robert McCarn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.