MicrosoftThis is a great addition for general users. It'd also be really helpful if additional guidance was available on DA evaluation, which can be confusing at times, including function signature details and improved formula tools. Taking MATCH as an example, the following formula returns a single value result when one might expect an array:
=MATCH(A1,B1:B5,C1:C2)
Stepping through Evaluate Formula with suitable inputs shows the third argument seems to be passed as a range and in order to return an array the range needs to be converted to an array explicitly: +C1:C2. On the other hand if the first argument is changed to A1:A2 stepping through the evaluation appears to show the conversion from range to array is implicit - presumably as the range is passed as values. It'd be nice if this was all made more transparent...
