Short transcript excerpt from a video discussion about Excel formula behavior. Speakers discuss surprising output (an extra '100' times a blank) and mention deep nesting of functions—SUBSTITUTE within MID within VALUE and others—when building advanced Excel formulas to 'elevate' skills.
Is so interesting that different tools have sort of preferred approaches. Yet again, it has gone for wrapped and blank and 100. I can't get my head around why it's adding a hundred times of the blank.
Yeah, I don't know why. Maybe because that is again, significantly longer than what the total numeric chain is. I'm not sure. Again, I'd have to kind of go back and dissect it. If you start from the beginning. I just love for those who really want to elevate their Excel, you've got a substitute embedded within the mid embedded within a embedded within a value embedded within a stump product.
Trust and Leadership Lessons for FP&A From 100+ Top Leaders with CFO Jon Laudie
