Forum Discussion
Simple math formula returning multiple values (It should not)
Hi. I have a simple work sheet setup it has 7 columns. I am doing a formula =(B2*C2)+(D3:J3). Excel keeps on wanting to return multiple results, using up 7 columns for the answer. In...
It should. If you specify
=(D3:J3)
you have referenced 7 cells and Excel will return 7 results. That said, the behaviour is new in Excel 365 and 2021. Older versions of Excel did something rather strange and picked a single value from the range or, sometimes, returned an error.