For many of us, before we’ve even finished thinking through a problem, we’ve already started writing IFs. Nested Excel IF statements work; they’re familiar, and they’ve been part of Excel for as long ...
Microsoft is changing a 40-year-old Excel rule by allowing a single cell to hold multiple values using new lists, arrays in cells, and nested arrays.