This is true but empirically, nobody cares: they're gonna do it in a spreadsheet. So spreadsheet software has to allow for this massive use case, and arguing they're doing it wrong gets no traction.