In the previous post, we learned that the SWITCH function allows us to look at a value and then return different results based on that value. But, what if instead of looking at one specific value, we need to consider multiple values in order to determine which result to return? Traditionally, we may have approached […]


For decades, Excel users have had the CHOOSE function and it has been able to power some wonderful formulas. But recently, we received the SWITCH function which provides much more flexibility. From a high level, both functions enable us to analyze a value and then return various results based on that value. But, SWITCH offers […]

Excel Breakout Puzzle 6

I think it’s about time for another breakout puzzle … yes! This breakout puzzle has an astronomy theme … you know, stars, constellations, the milky way, telescopes, and so on. I’ve always enjoyed looking up at the night sky. Being able to recognize stars and constellations helps me feel at home when I travel to […]