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.




Chapter 8 by Emese Felvégi and Robert McCarn.


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

Excel For Decision Making Copyright © by Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.